I've got a 8.1.43 vision window which I use as a recipe selection popup, with the cache policy set to Always. On the window are 6 dropdowns, populated by the Data property via an SQL query with a simple select, polling mode is off. I'm using the Selected Label property linked to a bi-directional memory tag to track which recipe is selected. About 10 operators open this popup up on their own clients a number of times per hour to select a recipe.
I previously had trouble with 7.9 and this popup which is why the cache policy is set to always which seemed to sort the issue out, but we have just upgraded to 8.1.43 and the issue has ocurred again when the memory tags are getting overwritten when a client opens the popup that may not have shown the latest updates, or if 1 client is open they might go back to design saved values. Removing the SQL query from the Data property stops this issue, so we are running like this at the moment, but that causes an issue when new recipes come online the dropdowns don't get updated.
Obviously I need to remove that query from the dropdowns to stop 6 identical calls, so do I move this to a memory tag and only update that tag when new recipes are added. Just looking to see what best practices are for this, and to avoid the error of the memory tags getting overwritten randomly.
Thanks.