-
Thanks Kieran, I compared my settings with yours and they are identical to so that was good to verify. You’re dashboard worked as expected in my browser. I tried to modify your data source in various ways to repo the error but with no success. I tried adding common columns to both tables, changing the table lengths, adding some character columns etc but I couldnt break it.
I also checked for browser errors on my dashboard but nothing is standing out.
When the issue appears, if I go to edit mode and execute the query (so input arguments are the same) the results returned are as expected, I press apply and the old records vanish. So I am happy the query itself is returning the expected values. Its a very odd one.
I can only conclude that there must be a browser error somewhere that’s making the difference on my side. I will probably try to rebuild the dashboard at some point to see if that fixes it.
For now, I have decided to change around my dashboard so that the different tables are viewed in separate data grids, and this may actually be more user friendly also, as it allows users to view both tables at the same time. Thanks again for the help