Select to view content in your preferred language

Another @pulldata not clearing cache question

191
1
Jump to solution
04-30-2025 10:15 AM
BigLouC
Frequent Contributor

Good afternoon, I notice that there is no plan to fix the cache issue as it says that it is by design on the bug page https://support.esri.com/en-us/bug/the-calculation-does-not-recognize-that-a-new-feature-i-bug-00015...

My question is I am using the workaround, but I still dont get the current information from the URL.

textsqlidschedulesqlid123456
texturlservice urlhttps://yadayada,com
calculateurlcurrentdatagets current dataconcat("${url}?t=", now())
calculatesqlidfilter concat("SQLid='",${sqlidschedule},"'")
calculatepermcurrschpermit current valuepulldata("@layer","getValue","attributes.Instructions",${urlcurrentdata},${sqlidfilter})
textcurrentvaluecurrent permit value${permcurrsch}

 

As you see above, I have to add an additional query to get a value.

The refresh does not work. I still get the cached value that was captured the first time.

Am I missing something or did I incorrectly write something?

Thanks all

0 Kudos
1 Solution

Accepted Solutions
BigLouC
Frequent Contributor

Ok, so thanks to all that saw this post.

I found another post where it fools the application by adding a random query. It works.

Thanks to @MobiusSnake 

https://community.esri.com/t5/arcgis-survey123-questions/pulldata-layer-seems-to-be-caching-results/...

 

pulldata("@layer","getValue","attributes.Instructions", ${url}, concat("SQLid='",${sqlidschedule},"' and SQLid <>'",string(random()),"'"))

View solution in original post

1 Reply
BigLouC
Frequent Contributor

Ok, so thanks to all that saw this post.

I found another post where it fools the application by adding a random query. It works.

Thanks to @MobiusSnake 

https://community.esri.com/t5/arcgis-survey123-questions/pulldata-layer-seems-to-be-caching-results/...

 

pulldata("@layer","getValue","attributes.Instructions", ${url}, concat("SQLid='",${sqlidschedule},"' and SQLid <>'",string(random()),"'"))