Forum Discussion

RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
2 years ago
Solved

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

The SQLTableEditor in question is used for user interactive CRUD pertaining to Rates used in a calculation. Use Case: I have a SQLTableEditor that holds rates.  When the table Save button is clic...
User Interface
  • RobbSalzmann's avatar
    RobbSalzmann
    2 years ago

    Thanks db_pdx 

     I do have an extra button to refresh my table.  This extra button confusing to the users.  Its not a natural UX action to click a Save button and then have to click an update button.  Save should do the updating.  The point of this is I should not need an extra button to refresh the ui after clicking a save button.  

db_pdx's avatar
db_pdx
Valued Contributor
2 years ago

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.