Filter Settings

Shortcut: Ctrl+F5

This dialog box allows you to specify how to filter the entries displayed in the grid.

Important: The filter, like the sort order, is dynamic. The changes you make to the entries are reflected immediately in the table. If an entry does not correspond to the criteria of the filter, it is removed from the visible entries.

Include entries that are flagged -- Set this option to include in the displayed entries the entries that have their Flag field set. This is the same as specifying "Flag = true" in the SQL condition.

AND -- Select this option to display only the entries that have both the Flag field set and match the SQL condition.

OR -- Select this option to display the entries that have either the Flag field set or match the SQL condition.

Include entries corresponding to the following condition -- Set this option to include in the displayed entries the entries match the specified SQL-like condition. The statement must be a valid expression. Meta characters must be escaped. Field names that have spaces must be enclosed between '[' and ']' (e.g. "[File name]"). Date/Time values must be enclosed between two '#' (e.g. "#5/27/2007#").

Examples of statements:

[Text_EN] LIKE '%file%'
Flag = true
Text_EN = Text_FR
Text_EN = Text_FR AND LEN(Text_EN) > 20

Examples -- Click this button to display a list of SQL conditions you can adapt to your needs.

Fields -- Click this button to display the list of the available fields.

Operators -- Click this button to display the list of the main SQL operators you can use in the condition.

Functions -- Click this button to display the list of the main SQL functions you can use in the conditions.

Characters -- Click this button to display the list of the characters that should be escaped in the condition.