BUILTIN.MNFILTER
This functions filters a record to specify a target value on a multiselect field.
Parameters
Parameter |
Required / Optional |
Description |
Acceptable Parameter Values |
---|---|---|---|
Relationship field |
required |
Represents the selected value on a multiselect field. |
– |
Operator |
required |
Holds the values supported when filtering relationship fields. |
|
Display field or empty string |
required |
A display field should be used if you are filtering a display field value of a relationship field. The empty string value should be used if filtering over foreign key values. |
|
boolean value |
required |
A boolean value helps specify if the filter should be case sensitive. |
|
value |
required |
The list of values to be included in the filter. |
– |
Syntax
SELECTBUILTIN_RESULT.TYPE_INTEGER("ROLE"."ID") AS "ID" /*{id#RAW}*/,FROM"ROLE"WHERE BUILTIN.MNFILTER("ROLE".accessprofiles, 'MN_INCLUDE', '', 'TRUE', '-2') = 'T'