Edit filter criterion – Metrohm tiamo 1.1 Manual User Manual
Page 256
228
Database
Edit filter criterion
With
Edit, Edit line
the dialog window
Edit filter criterion #
opens in which the filter
criterion selected in the filter table can be edited.
Link
[ AND ], OR
Selection of the logic operator with the previous filter criterion.
Field
Field name
Selection of the field from the fields shown in the determination table
(shown at the top) as well as all other fields available in the data record for
filtering for which a criterion is to be formulated.
Condition
Type
[ Text ], Number, Date
Selection of the type of format for fields in which several types are possible
(e.g. for
ID1.value
). For fields with a fixed type only this type will be shown.
Operator
[ = ], <>, empty, not empty
(for
type
=
Text
)
[ = ], <>, <, <=, >, >=, invalid, out of limits
(for
type
=
Number
)
[ = ], <>, <, <=, >, >=, Today
(for
type
=
Date
)
Selection of the comparison operator for the filter criterion.
Note
If for a date field the
Operator
Today
is selected then filtering will be carried out
for the current date. In the field
Comparative value
a range in days (
-9999 ... 9999
)
based on the current date can also be defined according to which filtering is to
be carried out.
Comparative value
250 characters, * as wildcard
(for
type
=
Text
)
Any number
(for
type
=
Number
)
Any date
(for
type
=
Date
)
-999 ... 999
(for
type
=
Date
and
Operator
=
Today
)
Selection or entry of the comparative value for the filter criterion.
Match case
[ on ], off
If this option is switched on then upper/lower case will be differentiated
when filtering
Text
type fields.