As a transitional step, this site will temporarily be made Read-Only from July 8th until the new community launch. During this time, you can still search and read articles and discussions.

While the community is read-only, if you have questions or issues requiring TIBCO review/response, please access the new TIBCO Community and select "Ask A Question."

You will need to register or log in or register to engage in the new community.

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