topic Re: Pulldata @layer seems to be caching results in ArcGIS Survey123 Questions

Pulldata @layer seems to be caching results

OlivierDemars1 — Wed, 15 Feb 2023 09:40:36 GMT

Hi,

I count the number of records related to a specific task this way:

pulldata("@layer", "getValue", "attributes.totalcount", concat(${url_query}, '?outStatistics=[{"statisticType": "count","onStatisticField": "objectId","outStatisticFieldName": "totalcount"}]'), concat("task_id ='",${task_id},"'"))

where ${url_query} is the feature layer url and ${task_id} the filter value for the task_id attribute.

It works fine but it seems that Survey123 is caching the result of the request which means that when I create another record related to the same task, the count is not updated.

I was able to confirm that by looking at the requests done by Survey123 with a tool like Fiddler.

This is really annoying for our workflow as it means that Survey123 has to be stopped and restarted for the request to be sent and the count updated.

Could this behaviour be changed?

Thanks,

Olivier

Re: Pulldata @layer seems to be caching results

MobiusSnake — Wed, 15 Feb 2023 13:10:16 GMT

Maybe try adding a cache buster parameter to the URL? Something like "xyz=1234567890" where the number is randomly generated?

Re: Pulldata @layer seems to be caching results

OlivierDemars1 — Mon, 20 Feb 2023 03:06:50 GMT

Great idea, it works, thanks.

I just changed my call like this:

Re: Pulldata @layer seems to be caching results

LWWCGIS — Wed, 05 Jul 2023 20:09:26 GMT

I have ran into the same issue, but I am using getRecord instead of getValue. I have a field (form_json) to store the json with it's calculation looking like this:

pulldata("@layer", "getRecord", "<PortalURL>?orderByFields=readingtime2 DESC", "1=1")

I then use pulldata again to populate the field I want with:

pulldata("@json",${form_json},"attributes.hscurrentmeterread")

I'm unsure how to use the random function as you did above to make my call refresh every time.

Re: Pulldata @layer seems to be caching results

LWWCGIS — Wed, 05 Jul 2023 20:37:07 GMT

I was finally able to get it. Needed to remove 1=1

Re: Pulldata @layer seems to be caching results

DavidRedondo — Sat, 15 Jul 2023 11:11:22 GMT

Hey guys, this is a really useful topic, I am trying to get the count of concrete selection on a field, and that's working well, but when I try to combine with other field to get the data filtered by both fileds it shows nothing...

pulldata("@layer", "getValue", "attributes.totalcount", concat(${URL}, '?outStatistics=[{"statisticType": "count","onStatisticField": "objectId","outStatisticFieldName": "totalcount"}]'), concat("lugar ='",'Casco Antiguo',"' and fecha_de_la_Recogida ='",${fecha_de_la_Recogida},"'"))

Ok, I just managed to see that the URL for the first field was in the general table (/0) and the last one in the repeat (/1), so I made another line:

pulldata("@layer", "getValue", "attributes.totalcount", concat(${URL2}, '?outStatistics=[{"statisticType": "count","onStatisticField": "objectId","outStatisticFieldName": "totalcount"}]'), concat("fecha_de_la_Recogida ='",${fecha_de_la_Recogida},"'"))

But even with this alone I cannot get any result 😞

Anyone can help me to figure this out? Thanks in advance!!

Re: Pulldata @layer seems to be caching results

DavidRedondo — Thu, 03 Aug 2023 09:32:01 GMT

any thoughts? 🙂

Re: Pulldata @layer seems to be caching results

DavidRedondo — Tue, 29 Aug 2023 12:17:01 GMT

ideas? 🙂

Re: Pulldata @layer seems to be caching results

BrittanyBankovich1 — Thu, 12 Jun 2025 15:38:18 GMT

Great trick, this works well, instantaneously, and can be tested in Connect.