Re: How do we add parameter in the data template to get the desired output

Brajesh Shukla-95078

Summary

Re: How do we add parameter in the data template to get the desired output

Content

Please correct the below things

1. Here parameter name and below sql column name is same i.e. loc . Please change the parameter name to p_loc and use condition like and loc=nvl(:p_loc,loc)

<sqlStatement name="Q_LOC">

select distinct loc from item_loc_soh

</sqlStatement>

2. Where you are using the Q_LOC? I cannot see this has been added to any group. If this sql is not required please delete that