With this dialog you can construct and edit search filters.
Example 1: Search for all firms in Berlinwith Inc in name.
select where
(
City = 'Berlin'
AND Firm = '*Inc'
)Example 2: Search for all companies in Berlin, with "Inc" or " AG" in name.
select where
(
City = 'Berlin'
AND (
Firm = '*Inc'
OR Firm = '* AG.'
)
)
Filter Name: Name of the filter.
Folder Name: Name of the folder. (Filters are stored folder-referred.)
Filter Editor Field: In this field you can edit the filter manually. Some processing steps can be made only by hand, as for example the insertion of new parenthesis-levels.
Insert a New Line: Above the current line a new line is inserted and can be edited then.
Delete Current Line: A click onto this button deletes the current line.
Test Syntax: With click onto this button a syntax-check is done.
Line Link Operator: Selection of the line-logic-link-operator AND / OR.
Fieldname: Selection of the field name for the current line. The selection box contains all field names of the current folder.
<=>: Selection of compare-operator. <> means in this case 'different from'Compare Value: The value specified here is compared with the field contents. The compare-value can begin or end with a *. For details see Filter-Syntax.
Text / number specifies whether the comparison value is to be evaluated (to compare) as text or as a number. Text is put in high commas.