The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Madesh's avatar
Madesh
New Contributor III
4 years ago
Solved

Parameters in GridView.

I am trying to create a dashboard with GridView as the component. In Gridview am using Dataadapter (SQL Query). I want to pass parameter to the GridView when displaying the data in the dashboard. C...
dashboards
  • ChristianW's avatar
    ChristianW
    4 years ago

    Sorry I thought, the gridview is the triggering object, but you are looking for a way to change the query using a parameter.

    If you have a sql data adapter, you can use the parameters in the sql script like here:

    I hope, this is what you are looking for?

    In the sample, Onestream replaces

    |!WFProfileCriteria_TCR!|

    with the parameter's value:

    = 'Houston.Register'

    and executes the query with this where statement:

    ... WHERE XFW_TCR_Register.WFProfileName = 'Houston.Register'  ...

IB's avatar
IB
New Contributor
2 years ago

Hi Christian,

I have a problem passing parameters with Multiselect=True. I want a list of the column to be passed to process a sql in the BR. Any help would be appreciated.

Thank You,

Indu

ChristianW's avatar
ChristianW
Icon for OneStream Employee rankOneStream Employee
2 years ago

Did you encapsulate the parameter with brackets?

param = [|!MyParameter!|]

This is needed to prevent the business rule call from misinterpreting the commas in the comma-separated list.