WebFOCUS: Dynamic filter values against a masterfile on stored procedure parameter

Hi All,

Usually in any table request when we want dynamic filter values we give the where clause in the below format

WHERE CAR.COMP.CAR EQ &CAR.(OR(FIND CAR.COMP.CAR,CAR.COMP.CAR IN car|FORMAT=A16)).CAR:.;

Simillarly, is it possible when we have a table request against a masterfile created on stored procedure which has parameters (filters) to be passed.

I have developed a report in designer and because the WHERE clause like above to get the values dynamically is not working against a parameter filter from masterfile created on stored procedure, the paramter on the designer page is showing as an  editbox, but I am looking to show a dropdown with multi-select option.

Any help is appreciated!

Thanks,

Subbu.

(1) Answer

Login