How To Trigger Dashboard Refresh from SQLTableEditor Save Data Server Task (Save button)

Hi RobbSalzmann ! 
Hope you are doing fine.
I am just thowing at you an idea I did not test : Have you tried with a Save Data Event Handler ? This is run in order to track all save events in an application.
If it captures your save, then you could throw a refresh of the gridview.
I know it is super theoretical 😀 but I have not time to test now. I could not find any info in Golfstream App!
Keep me posted.
Nic

Hi NicolasArgente Can you help me understand how to specify a "Save Data Event Handler" in SQLTableEditor?

I'm probably staring straight at it and can't see it. 😛

Robb, just go to your favorite part of OS : Creating a business rule. Select like below : 

My understanding is that anytime you save something into OS, it will check that BR. It might be an overkill. But if you click the save, it should look at this SaveDataEventHandler. Once again, never tried and to be honest, i can not find any info on it!

Nicolas,
I tried doing this.  When I click the Save button in the SQLTableEditor, this event handler is not called.  I verified this with a print to the error log:

Edit: not working with the light testing I performed

Hi Robb: I'm going to throw another untested idea at you. In brief, create a custom Save Data Task that triggers a Selection Changed UI task as the final step (which would hopefully achieve the refresh you want).

• The SQL Table Editor has the default option for custom save events in the component properties under 'SQL Table Editor > Server Task'.
• You specify the custom save task in a DashboardExtender BR under the function type DashboardExtenderFunctionType.SqlTableEditorSaveData.
  • I believe this requires that you specify the full custom save logic.  Edit: not needed, the default code available within the SqlTableEditorSaveData works without needing modification.
  • You can probably reference CPP / PLP BR's for how this works.
• Then the crux of the concept. After the actual custom save logic, pop a New XFSelectionChangedUIAction. From the snippet editor: Dim objXFSelectionChangedUIActionInfo As New XFSelectionChangedUIActionInfo(selectionChangedUIActionType, dashboardsToRedraw, dashboardsToShow, dashboardsToHide, dashboardForDialog). Hopefully that will trigger your desired refresh.
  • Edit: the above does not work in the testing I did.

I might try and mock this up if I have time today.

Same here, bummer.  I had hope for minute there ... 😆

The problem is the TaksResult objects.  The XFSqlTableEditorSaveDataTaskResultTaskResult lacks these two properties needed for this to work:
XFSelectionChangedUIActionInfo? ModifiedSelectionChangedUIActionInfo { get; set; }
bool ChangeSelectionChangedNavigationInDashboard { get; set; }

The SQLTableEditor seems to be a one-off component in dashboards, like a brother from another mother.  It also uses a different TaskResult type than everything else.