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


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!



(1) Answer