Code to trigger "Refresh" in an updatable dashboard

Epicor ERP 10
1

Creating a new Updatable Dashboard that has a special “custom action”… inside the custom action, I would like to trigger a refresh of the dashboard.
Does anyone know how to do this?

2

was about to say @Banderson has some code for this.

1 Like
3

I think you have to do it on the client side, but you should be able to make an event to trigger it. One of the problems with this though, is the grid has to be clicked on before it will work. I haven’t found a workaround for that.

	private void PaintRefresh_Click(object sender, System.EventArgs args)
	{
		// ** Place Event Handling Code Here **
			MainController.AppControlPanel.HandleToolClick("RefreshTool", new 
			Infragistics.Win.UltraWinToolbars.ToolClickEventArgs(MainController.MainToolManager.Tools["RefreshTool"], null));
	}
4

You shouldn’t need to do this? I say that because after update occurs in the bpm directive for your custom action, the dashboard result data gets refreshed, or you should refresh the result data yourself in the custom code.

5

Yes, I am refreshing the data in the table with my code… the PROBLEM is that as a result of the “custom code” some of the rows should no longer show, and therefore needs to be removed. I have figured out how to remove them from the “results” table itself, but the screen doesnt refresh.

6

I see how this would work, but I dont want to constantly refresh with each click.

7

Throw that code after your custom action. It’s just an example.

This is what you need.

MainController.AppControlPanel.HandleToolClick("RefreshTool", new 
			Infragistics.Win.UltraWinToolbars.ToolClickEventArgs(MainController.MainToolManager.Tools["RefreshTool"], null));
8

I think I may have figured out an even easier option.

  1. add a new calculated field to the query called “HideIt”
  2. in the dashboard grid, hide any rows where “HideIt” is true
  3. in my Actions, set this value to true… the row will immediately disappear from the grid without a refresh.
    WOW… that was easy… and it is faster than doing the refresh.
2 Likes