The following query list all …

… ongoing upper projects.

As an extension of the query, the field project manager in the document project is searched for with an AND-Link. This field is a multiple selection and contains many numbers of entries of type employee. Employee.Name LIKE $Project Manager asks the field name (last name) in the document employee and the requirement Project Manager → Employee** (field project manager points to employees) provides for the assignment to the field project manager.

When performing of the advance search in the query manager, is first queried the last name of the project manager and …

Beim Ausführen der Profi-Suche im Abfrage-Manager wird zunächst der Nachname des Projektleiters abgefragt und …

… then all the projects are listed, where the employee Schaub is one of the project manager.

The advanced search can also be used in the chart system to determine the input data of the selection (more about Charts in Section 2.5).