I was able to implement direct discovery in my app but the data does not get refreshed when it is changed in the database.
I am aware of the setting : SET DirectCacheSeconds=X;
Which stores the result set of a particular selection for X seconds. For my app I have X=10 sec.
Lets say a user selects Customer A and we show Sales as 100 for that customer. Now data is changed to 200 for the same customer in the data source. This data is not updating automatically after 10 seconds in my text box unless I deselect and re-select the same customer. Is there a variable or any other way so that my direct data auto refresh whenever its values changes without removing my previous selection?