List of Options Attributes – Multiple Selection

Only custom objects, enterprise controls, enterprise risks, and events support filters for Multiple Selection attributes.

To illustrate these attribute filters, consider a Multiple Selection List of Options attribute named "multiselect" which can have one of the following values: "op1", "op2", and "op3". Also consider the following objects and their respective values:

Object 1: op1

Object 2: op2

Object 3: op3

Object 4: op1, op2

Object 5: op1, op3

Object 6: op2, op3

Object 7: op1, op2, op3

Object 8: "empty"

 

EXAMPLES:

Filter by objects with "op1":

{RMUrl}/api/objects/object?$filter=multiselect/any(i: i/Caption eq 'op1')

Returns:

Object 1, Object 4, Object 5, and Object 7

 

Filter by objects without "op1":

{RMUrl}/api/objects/object?$filter=multiselect/any(i: i/Caption ne 'op1')

Returns:

Object 2, Object 3, and Object 6

 

Filter by objects with "op1" and "op2":

{RMUrl}/api/objects/object?$filter=multiselect/any(i: i/Caption eq 'op1' and i/Caption eq 'op2')

Returns:

Object 4 and Object 7

 

Filter by objects with "op1" or "op2":

{RMUrl}/api/objects/object?$filter=multiselect/any(i: i/Caption eq 'op1' or i/Caption eq 'op2')

Returns:

Object 1, Object 2, Object 4, Object 5, Object 6, and Object 7

 

Filter by objects without completed attributes, that is, with value equal to "null":

{RMUrl}/api/objects/object?$filter=multiselect/any(i: i/Caption eq null)

Returns:

Object 8