Multiple Parameters

Multiple-value parameters let users select more than one item — for example several counties or product lines.

Goal

Configure a multi-select parameter for IN-list filtering.

Prerequisites

• Parameter Manager is open

Steps

1. Add or edit a parameter.
2. Set selection to Multiple.
3. Optionally configure lookup SQL that returns the allowed values.
4. Provide default values as a list when needed.
5. Update query filters to use multi-value syntax ($X{IN, …}) so SQL accepts the list.

[ Screenshot: Multiple parameter settings ]

Result

Preview prompts allow selecting multiple values, and the query returns rows matching the selection.

Tips

Warning

Cascading lookups that depend on a multi-select parent need compatible lookup SQL. Prefer $X{IN, …} when the parent is multiple.

See Also

• Single Parameters
• Cascading Parameters
• Query Builder