Hi All,
There can be a scenario where we might need to show one value in the report and a different value to the actual query. Lets say a person_name to the user and person_id to the underlying data model.
Here the query builder for the parameter shows only single query field :
==>
So in this case we can write the query as below
select A , B from dual;
Here the field A will be shown to the user and the field B would be passed to the data model.
Thanks,
Srikanth
There can be a scenario where we might need to show one value in the report and a different value to the actual query. Lets say a person_name to the user and person_id to the underlying data model.
Here the query builder for the parameter shows only single query field :
==>
So in this case we can write the query as below
select A , B from dual;
Here the field A will be shown to the user and the field B would be passed to the data model.
Thanks,
Srikanth