Description

In my Query, I use on selection field with IN list operator.
Some times the end-user doesn't want to give any value in the list but want to extract all the records which matched with other selection fields.
However I get an error when I delete all the IN list values , saying the list has no values to export.
I want the end-user to have this flexibility to remove any or all of the values in the list,

Applies To

Query

Cause

Dynamic Lookup List : Currently we do not support empty Dynamic Lookup List while running the script.
Static Value List : The values cannot be emptied out if list is already defined with some values.

Immediate Workaround

For a workaround, static value list can be declared empty while applying in list operator in criteria tab. Then user have option to run the script without defining any values as well as providing values accordingly.