Converting a Filter Value List to a Variable Expression

When you insert a check box filter using the EQ (equal) or NE (not equal) relation for a field that has a small list of possible values that do not change often, you can convert the filter to a variable expression that improves performance.

The option to convert the filter to a variable expression is on the Values option of the filter pane drop-down menu, as shown in the following image.

The variable expression is added to the synonym under Variables. Right-click the variable expression and click Properties to see the expression, as shown in the following image.