Working with Data Filters

Data Filters

Data filters let you set up queries to find messages containing specific data such as patient IDs, names, and order types codes. Queries can filter on specific message elements: segments, fields, components, and subcomponents.

  • Messages are composed of segments.
  • Segments contain fields.
  • As an option, fields can contain components.
  • As an option, components can contain subcomponents.
Pinpoint_Filter_DataThis filter on PID.2.1 builds a query to deliver all messages containing the ID number above.

Select Message Data to Build Filters

This is the recommended method for building data filters. Once you’ve built a query this way, you can also modify the Filter Operators to change your filter criteria.

  • In the Messages area, look for the field containing the data you want to filter on. It could be a patient name, a date, a location, or another string.
  • Right-click within the field. A menu appears.
  • Click Add Data Filter.

    Pinpoint_Filter_Data5

  • The filter is automatically created within the Data Filters tab, and the data you filtered on is highlighted within the Messages area . The default filter operator (“is” “=”) is applied.
    Pinpoint_Filter_Data2Click to enlarge.

     

Build Data Filters Directly

This is an alternate method for building data filters. This method is helpful when applying complex filter operators.

  • In the Data Filters area, click the Add button.
  • Click on each of the Segment, Field, Component, and/or Subcomponent dropdown lists to configure the message structure you’re filtering for. (Click image to enlarge.)
    Pinpoint_Filter_Data3
  • Apply operators. Select “IS” if you want your results to INCLUDE the data you’ll be filtering on. Alternatively, select “IS NOT” if you want your results to EXCLUDE the data you’ll be filtering.
  • Continue applying operators. Select = , like, present, or empty, depending on the query type. See Data Filter Operators for more detail.
  • In the Criteria field, type the data you’re filtering on. Press the Enter key. Results automatically appear in the Messages area.

Case Sensitivity

You can make your data filter queries case-sensitive.  This is helpful when you need to identify data that might have been entered in all caps (JOHN SMITH) instead of title case (John Smith).

  • Click Tools, Options, and go to the Settings tab.
  • Check or uncheck the Make data filters case-sensitive checkbox as needed.

Global Find

You can create filters that query the entire log, instead of a single segment or field. Simply omit the segment and field from the filter. The results in the Messages area cover all occurrences of the value you specified in the filter.
Pinpoint_Filter_Data4

Basic/Advanced Mode

While editing your filters, you can switch between Basic and Advanced Mode. Advanced Mode will show you advanced settings for your filters. These settings will help you to construct more complex filters using AND/OR operators and parentheses for nesting. Otherwise, each filter will be applied one after the other.

If your filters contains advanced settings and you switch back to the Basic Mode, these settings will be lost.

Advanced Mode

Pinpoint_Filter_Data_AdvancedMode

In this example, we want to create filters to get messages where (MSH.3 = MyApplication) and (PID.2.1 = 54738474) or (PID.18 = P5847373).

These filters will include the following messages:

 Pinpoint_Filter_Data_IncludedMessages

And they will exclude these messages:

Pinpoint_Filter_Data_ExcludedMessages