I have created a command object having the query like :

select branch_code from sttm_branch

union

select 'ALL' from dual.

 

Also i have created a Dynamic parameter but i am not able to see the values fetched from the command object anywhere.

 

I am not able to find any option in the edit parameter window to link the command object to the parameter.

 

Could you please let me know how to see the values of the command object in the parameter?

 

Thanks

Ishu