[[|{{|previous}}]] [[en:handbuch:handbuch|{{|Home}}]] [[|{{|next}}]]

====== 3.05 Using Advanced Search (continued 3) ======


===== Another example (project search) =====


The following query lists all ...

{{:en:handbuch:kapitel_3:reports11.jpg|}}

... ongoing top projects.

{{:en:handbuch:kapitel_3:reports12.jpg|}}

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.

{{:en:handbuch:kapitel_3:reports13.jpg|}}

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

{{:en:handbuch:kapitel_3:reports14.jpg|}}

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

{{:en:handbuch:kapitel_3:reports12.jpg|}}

The advanced search can also be used in the chart system to determine the input data of the selection (more about charts in [[en:handbuch:kapitel_2:2.05_auswertungssystem|Chapter 2.05 Chart Evaluation System]]).

{{:en:handbuch:kapitel_3:reports16.jpg|}}