Database Catalog

Users can launch a query by pressing the Database catalog button. A list containing all values which have been entered into this field for indexing is created and opened. The user can restrict the search by entering values in the catalog field or in other fields. These entries will be evaluated during the search. Checkboxes are evaluated differently depending on the situation.

The user can enter values from the created database list or enter new values in the catalog field.

From the properties window of a text field, select the Catalog row and then the Database entry. This catalog will not be configured.

The database catalog has no function in test mode.

Database catalogs are supplemented by an autocomplete function. The user is then given a list of suggestions based on existing entries when they enter three characters or more when searching, editing, or creating.

The rights system for the object type is taken into account; clauses on referenced folder or register types are not taken into account.

You can prevent the access rights from being taken into account by adding the following entry on the Database catalog tab:

IGNORESECURITYCHECK=JA

Other fields that have already been populated are also taken into account when determining the suggestions.

You can prevent already completed fields from being taken into account during the creation and editing process by adding the following entry to the Database catalog tab:

IGNOREOTHERFIELDINEDIT=JA

Auto-complete can be switched off for all database catalogs via an entry in the as.cfg file, located in the \etc directory of the data directory:

[SYSTEM]
USETYPEAHEADONDBCATALOG=0

Fields with a database catalog require a database index for the corresponding table column for auto-complete.