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' ...
