The following query lists all …

… ongoing top 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 queries 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 the advanced search in the query manager, first the last name of the project manager is queried and …

… 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 Chapter 2.05 Chart Evaluation System).