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
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...
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' ...
ChristianW
OneStream Employee
OneStream EmployeeThere is a Bound Parameter option in the sql table editor:
and an Column name for bound parameter option to define the column of the table, that will populate the parameter:
You only can populate the parameter with one column only.
Thanks Christian.
Hope this option is available when using SQL table editor. Is there any option available in GridView?
- ChristianW
yes, these options are in sql table editor and in grid view. The screenshots are from a sql table editor.
Hi Christian, i have tried the same in GridView but its not working. Is there any KB article for this to go-through.
- ChristianW
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' ...