Operators

Data filters and operators let you define validation rules. The operators let you build filter queries, ranging from simple to complex. The most basic operator set consists of the use of “is” and “=”.

Pinpoint_Filter_Operator

These are the default operators in the Add Data Filter command, available on the right-click dropdown menu in the Last Result area.

The other data filter operators let you build sophisticated filters for analyzing HL7 data.

 

Operators List

Operator Action
is Includes messages that contain this data
is not Excludes messages that contain this data
= Covers messages with an exact match to this data (this is like putting quotation marks around a search engine query)
< Less than. Covers filtering on numeric values.
<= Less than or equal to. Covers filtering on numeric values.
> Greater than. Covers filtering on numeric values.
>= Greater than or equal to. Covers filtering on numeric values.
like Covers messages that include this data. Covers filtering on numeric values.
present Looks for the presence of a particular message building block (such as a segment, field, component, or sub-component)
empty Looks for an unpopulated message building block (such as a segment, field, component, or sub-component)
in Builds a filter on multiple data values in a message element rather than just one value.
in table Looks if the data is in a specific table of the referenced Profile.
matching regex Use .NET regular expression syntax to build filters. For advanced users with programming backgrounds. Learn more about regular expressions here:

This is also a quite good utility to hep you create complex regular expressions: