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. Wheninput_fieldis an Instance field, the function accepts only onecomparison_valueparameter. Wheninput_fieldis a Multi-Instance field, the function accepts multiplecomparison_valueparameters.
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])