INSTANCE_EQUALS
Description
INSTANCE_EQUALS
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 checks if the first argument exactly matches the instance values
provided in the other arguments.Syntax
INSTANCE_EQUALS
(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_EQUALS([Worktags], [Cost Center
1],[Cost Center 2])