Metrohm tiamo 1.1 Manual - 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.