Query editor : "In" clause with parameter [Done]

The capability has been added in version 4.5.1. It works as follows:

1) Create a parameter of the “Multiple choice” type

In the Parameter Editor, create a new “Multiple choice” parameter and populate the list of acceptable values.

:bulb: Tip: To quickly populate the list of acceptable parameter values from a database field, you can copy it from the list of field values and paste it in the parameter properties.

image

2) Use the parameter in a query condition

Create a condition of type “In list”. In the condition properties specify that a parameter should be used.

Note that in this condition mode only parameters of type “Multiple choice” can be used.