Q&R Query Tasks › Data Filters Task

Data Filters Task

The Data Filters task is used to specify certain conditions that the data must meet before it is included in the query. For example, you can include data from specific SYSIDs or for CPU time greater than one second.

The columns in the Data Filters task panel include the following:

Element

Specifies an element from the data that is to be compared.

Operator

Specifies if the elements in the Element column and element values in the Value/Element column must be:

Operator

Description

EQ

equal to

LT

less than

LE

less than or equal to

GT

greater than

GE

greater than or equal to

NE

not equal

Note: When making character comparisons, you can use a colon (:) after any of the comparison operators to compare only the first character or characters of the value or element. Q&R Workstation truncates the longer value to the length of the shorter value during the operator phase.

Value/Element

Specifies the value or another element from the data, to compare against the element.

Connector

Specifoes the relationship of the element conditions. The relationship can be one of the following:

Connector

Description

AND

both are true

OR

either one is true

;

independent of each other
Find Element

Specifies the element information from a list of available elements.

Remove Row

Deletes the highlighted conditions.