Skip to Content

Filter Input Parameter with a table column

Jul 19, 2017 at 08:08 PM


avatar image
Former Member


I have a requirement to filter Input Parameter with a list of values(by default). The list of values should be populated from a table. I tried defining IP with 'procedure' and 'Derived from Table'. If I understand correctly, those options are not capable to return multiple values. I tried 'Column' option and chose the table name/column. I used this IP in the filters using In() operator. When I try to preview data, the IP prompts me for input and by default it is empty. Not sure how can I set IP by default to list of values.

Appreciate your inputs.

Thank you,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers