Another @pulldata not clearing cache question

BigLouC — Wed, 30 Apr 2025 17:15:31 GMT

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-000158969

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

text	sqlidschedule	sqlid	123456
text	url	service url	https://yadayada,com
calculate	urlcurrentdata	gets current data	concat("${url}?t=", now())
calculate	sqlidfilter		concat("SQLid='",${sqlidschedule},"'")
calculate	permcurrsch	permit current value	pulldata("@layer","getValue","attributes.Instructions",${urlcurrentdata},${sqlidfilter})
text	currentvalue	current 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

Re: Another @pulldata not clearing cache question

BigLouC — Mon, 05 May 2025 12:48:03 GMT

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.

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