I have configured a UI with display of table sourcing from Data Page which has loading mechanism of every four hours with Personalize Table option enabled in table configuration.
When user is launching the UI first time - system is referring the data page and running the query which is configured in data source of data page.
The same query is getting hit again when user is trying to switch view that has been saved earlier even though 4 hours timeframe is not met…!
Can we get rid of having the DB query hit within 4 hours time frame when switching the views ?
@SanthoshRanga
Hi Santhosh,
As we discussed earlier, This is the Expected behaviour of the system. When we create a new session by logging in into the Environment and switch between the Custom Views of the gird, at first, new clipboard instances are getting created for each view for the first time.
Also, DB query is getting triggered for the first time when switching between Views because every view has different query generated at backend.
Later, when we are switching the Views No DB query is getting triggered as it will take data from cache.
This functionality is independent of the Load Management which is set to 4 hours in your case. Load Management comes into picture when we have Active session for the same time and when that time past then Load management triggers and data is refreshed.