Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference MEMBER
Functions and Expressions Reference Guide
150
MEMBER
The MEMBER function searches a series, looking for a single specified object in the
series. If any object in the series matches the specified object, MEMBER returns
TRUE. If there is no match, MEMBER returns FALSE.
Syntax
MEMBER (single-object-expression , series-object-expression)
- or -
MEMBER (single-object-expression , { literal, literal … })
Meaning
MEMBER (object_to_look_for , series_of_objects_to_look_at)
Returns
This function returns TRUE or FALSE
Returns TRUE if object_to_look_for matches one of the values in
series_of_objects_to_look_at.
Returns FALSE if object_to_look_for does not match at least one of the values
in series_of_objects_to_look_at.
The two arguments, object_to_look_for and series_of_objects_to_look_at,
must be objects of the same item interpretation or the same group type. For
example, if object_to_look_for is a date/time item,
series_of_objects_to_look_at must be a series of date/time items.
Examples
MEMBER (EntityIDCode:Name, {"BT" , "ST"})
The example above tests whether EntityIDCode has one of a particular set of
literal values.
MEMBER (Store# , EntityIDCode:Name)
The example above tests whether Store# has the same value as any
EntityIDCode:Name.