Another @pulldata not clearing cache question

BigLouC

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

BigLouC

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/m-p/1258438#M47492

 

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