How to map one parameter value to the multiple columns
Hi,
I have a table like as mentioned in the screenshot. I would like to pull the rows based on the parameter value.
Data Model Query
select * from supplier
where usage1 = &1
and usage2 = &1
and usage3 = &1
and usage4 = &1
I have only one parameter with the list of values(drop down list). This parameter contains all values.
select distinct usage from supplier
where usage1='AP' --> It always returns only one value i.e AP. And this parameter should refer to the usage1 in the Data Model.
UNION
select distinct usage from supplier
where usage2='AR' -> It always returns only one value ie. AR. And this parameter should refer to the usage2 in the Data Model