INSTANCE_IS_SUPERSET_OF
Description
INSTANCE_IS_SUPERSET_OF
is a row function that compares a Multi-Instance field to either a Multi-Instance field, an Instance field, or to a list of instance values, and returns True if every instance value exists in the first argument, and False if at least one doesn't exist.Syntax
INSTANCE_IS_SUPERSET_OF
(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.
- 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_IS_SUPERSET_OF([Worktags], [Cost Center 1], [Cost Center 2])