Data SourcesTree StructureSearchSortingNew...Importing DataFilterCache, RefreshData FormProperties
Up

Create/Edit Filters

Page Index

Filter Syntax
Gerneral hints to filters

With this dialog you can construct and edit search filters.
Example1 for a Search Filter
Search for all firms in Berlinwith Inc in name.

select where
(
City = 'Berlin'
AND Firm = '*Inc'
)
Example2 for a Search Filter
Search for all companies in Berlin, with "Inc" or " AG" in name.

select where
(
City = 'Berlin'
AND (
Firm = '*Inc'
OR Firm = '* AG.'
)
)
Filter Syntax
Tips to the filter syntax
Dialog Elements
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 defines, whether the compare value is to compare as text or as a number. Text is put in high commas.