INSTANCE_CONTAINS_ANY
Description
INSTANCE_CONTAINS_ANY
is a row function that compares a Multi-Instance or Instance field to either a Multi-Instance field, an Instance field, or to a list of instance values, and returns True if at least one instance value exists in the first argument, and False if none of them exist.Syntax
INSTANCE_CONTAINS_ANY
(input_field
, comparison_value
, [comparison_value
])Return Value
Returns one value per row of type Boolean. This function returns NULL when it receives a Text value that isn't formatted as a valid instance value (WID format).
Input Parameters
- input_field
- Required. A field of type Multi-Instance or Instance.
- comparison_value
- Required. A field of type Multi-Instance or Instance, or a Text value of a valid instance value.
Examples
Compare the Worktags Multi-Instance field to the Instance fields
Cost Center 1
and Cost Center 2
:INSTANCE_CONTAINS_ANY([Worktags], [Cost Center 1], [Cost Center 2])