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
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!