Conditions for Catalogs

To define a condition for a catalog:

1. Select a catalog field. A dialog box is opened, allowing you to define the condition for the field.

   

   The available catalog values are listed to the left. Use as Parameter is at the top of the list. You can use this value if the comparison value should be entered whenever the query is run, see Parameters and Predefined Queries.

2. Choose the appropriate operator, e.g. = (equal) to determine that the condition should return records where the value of the catalog field matches the comparison value.
3. Select Fixed to compare the contents of the field with a fixed value from the list of entries. Select Field to compare the contents of a field, see Comparing Field Contents. The Text option is also available for variable catalogs, see Conditions for Variable Catalogs.
4. Double-click on an entry under Available fields to use it as a comparison value. The entry is moved to the right under Selected Fields.
5. Double-click on an item in the right area to remove it.
6. Click on OK to return to the query.