Skip to Content
avatar image
Former Member

Filter Input Parameter with a table column

Hi,

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,

Anjum.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers