Exists in a List or Map

The Exists in a List of Map criterion is only available at database column attributes with a List or Map data type.

It allows you to specify a value to search for within the series of values listed within the attribute's value.

For example, at the following List field value: “[1, 2, 3, 4, 5]”, provision of value “4” would satisfy the criterion. Similarly, at the following Map field value: “{'Map1': 1, 'Map2': 4}”, provision of value “1” would satisfy the criterion.

When creating or configuring an Exists in a List or Map criterion, the Criterion Builder looks like this:

The [value] field is displayed using a control accordance with the attribute's data type. Provision of a value is optional; if you do not provide a value, a Null value is used.