Dashboard Auto-Refresh on Filter Value Change

Kinetic ERP
, ,
1

My apologies if this has already been answered on another post.

I have created a dashboard where one of the queries has a filter added so users can enter a customer number, then hit Refresh to apply the filter.

I thought perhaps it would be helpful to have the query update without having to manually click the Refresh button. I figured there might be an option for this, but didn’t see anything.

Then I thought to customize the filter panel, and add an oTrans.Refresh() to AfterFieldChange, but from what I can tell, there is no oTrans available.

Has anyone ever successfully pulled this off?

2

Quick update on this post:
I did the screen customization so it will run code when the value changes (Validating). oTrans.Refresh() is in fact available, but it doesn’t refresh anything except for the Filter panel. I did a Trace to see what happens when I click Refresh, and it appears that I would need to leverage DynamicQueryDataSet, but I’m not quite sure how to do that.