› Expression editor › Actions with elements › Add functions and expression objects › List of expression objects › SQL functions › WHERE_IN and WHERE_NOT_IN operands

WHERE_IN and WHERE_NOT_IN operands

Kofax Insight supports filtering with "WHERE_IN" and "WHERE_NOT_IN" operands.

Instead of setting expressions separately, you can filter data by multiple specified values in a single SQL function.

To do so, navigate to Expression editor.

  1. When you start typing WHERE_IN or WHERE_NOT_IN, the system prompts you to complete the operand automatically.

  2. Use only constants to enter the WHERE_IN and WHERE_NOT_IN values:

    a. expr: Specify the required table field

    b. values: Specify the values to return. After each value, press Enter. Also, you can use commas to separate values.