Forum Discussion

jwagner's avatar
jwagner
New Contributor III
9 months ago

Updating a OneStream Application Table through Dashboard Extender/SQL Table Editor

Looking for some sample code to help me get started with adding in a new row through the SQL Table Editor, where a few of the columns are prepopulated on row addition through Dashboard Extender BR Code

Dashboards
  • jwagner's avatar
    jwagner
    9 months ago

    I was able to find a bit of a workaround for this.  I created a Dashboard String Function which returns the current row count + 1 as a literal parameter, and I am using that as the default value for the column format aka a new row default for the row column.  (Which is a XFBR String named |!DivisionMapping_RowCount!|)

    DashboardStringFunction Code 

    Workspace Parameter Configuration 

    SQL Table Editor Column Format Configuration 

     

  • jwagner's avatar
    jwagner
    New Contributor III
    9 months ago

    I was able to find a bit of a workaround for this.  I created a Dashboard String Function which returns the current row count + 1 as a literal parameter, and I am using that as the default value for the column format aka a new row default for the row column.  (Which is a XFBR String named |!DivisionMapping_RowCount!|)

    DashboardStringFunction Code 

    Workspace Parameter Configuration 

    SQL Table Editor Column Format Configuration 

     

  • Henning's avatar
    Henning
    Valued Contributor II
    9 months ago

    Hi, just a general note of caution on this also for the wider audience, referring to the title of this post "Updating a OneStream Application Table". I highly recommend not updating application tables using SQL. By doing this one circumvents the normal API calls and other functions used for this which typically includes an audit trail and ensures the integrity of the whole system. By just changing items directly in the tables, one risks all of that and likely looses OneStream support in case this becomes a problem at some point.

    • jwagner's avatar
      jwagner
      New Contributor III
      3 months ago

      Hi Henning, I was updating a custom Application table that I created.  But I do understand the point of what you are getting at.