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.
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
Solved! Go to Solution.
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
pulldata("@layer","getValue","attributes.Instructions", ${url}, concat("SQLid='",${sqlidschedule},"' and SQLid <>'",string(random()),"'")) |
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
pulldata("@layer","getValue","attributes.Instructions", ${url}, concat("SQLid='",${sqlidschedule},"' and SQLid <>'",string(random()),"'")) |