Filter Editor

The Filter Editor can be used to build complex statements to filter records from a single Session (in Record Management) or across Sessions (in Query Management). It displays the criteria in a tree structure where the nodes are the logical operators linking the conditions under them.

 

A single condition still appears under a node. The query criteria in this image will return all records where the SRR Code contains the letter W.

 

 

If another condition is added underneath the And node, the filter criteria will return records where both the conditions are true:

 

[Conditional Comments] contains 'AD'

AND

[SRR Code] contains 'W'

 

 

For more complex filtering criteria, there can be multiple groups of conditions, each with its own logical operator node. This filter criteria will return records that match the following expression:

 

([SRR Code] contains 'W' and [Conditional Comments] contains 'AD')

OR

([SRR Code] contains '3' and [Length] < 60)

 

 

 

 

A context menu can be accessed by clicking on any of the logical operator nodes, which gives access to change the operator, remove the group, add a new group, or add a new condition. Other elements of the Filter Editor interface are labeled in the image below.