topic Re: Pulldata @layer caches values in ArcGIS Survey123 Questions

Pulldata @layer caches values

PanGIS — Thu, 07 Sep 2023 13:44:51 GMT

Hello!

I am using the pulldata@layer to count the no. of records and add one.

the configuration of the xls seems to be perfect as I do have the totalCount and the increment.

But it works only once on each device, then the count is cashed and the only way to get rid of the value is to uninstall the survey123 field app, not even delete the survey or clear the cache from the app settings.

Tested on Field App on Windows and Android. even on the preview of Survey123 Connect the value is never updated.

Any thoughts?

thanks!

This post seems to be solved with a solution that I did not understand: Solved: Pulldata @layer seems to be caching results - Esri Community

Re: Pulldata @layer caches values

abureaux — Thu, 07 Sep 2023 17:26:31 GMT

Honestly, not sure offhand. But that post you linked does sound like the issue you are experiencing.

Out of curiosity, did you try this? I see you also have 1=1 in your formula.

Re: Pulldata @layer caches values

IsmaelChivite — Thu, 07 Sep 2023 23:16:55 GMT

@PanGIS Survey123 is in fact caching the request. The workaround is to add an extra parameter to the URL with a string that always changes to avoid caching.

For example, concat(${yourURL},"&t=",now())

This is a known problem logged as BUG-000158969 . The bug is in the queue for resolution but for now the workaround above should do.

Re: Pulldata @layer caches values

PanGIS — Wed, 13 Sep 2023 09:09:23 GMT

Hi @abureaux It was my first try but in my case, the totalCount disappeared from the form and it was showing nothing also on the incremental field.

It could be that I removed it in the wrong way though.

Anyway the solution provided by Ismael worked.

Thanks!

Re: Pulldata @layer caches values

Jenny31 — Fri, 20 Oct 2023 21:48:25 GMT

Hi Ismael, I have the same problem because I am trying to take the information from an existing view where the status of the assets from the previous day is, but when I call this view in the survey using pulldata, it does not take the most recent status.
This is the last part of my pulldata : concat("ID = '",${ID_NO}, "'")

I don't know how to clear the cache.

Thank you,

Re: Pulldata @layer caches values

City_ofNorth_Bay — Thu, 19 Dec 2024 17:45:57 GMT

Just a quick note- if this is the first query parameter after the url, concat(${yourURL},"?t=",now()) works best. (At least for me.)