Creating New Queries 

Use

You can use InfoSet Query for flexible data analysis that you cannot carry out with standard reports. By simply choosing selection and output fields, you can define the report you need, and display a results list. You can repeat this process as often as you like. You do not require programming skills to create reports using InfoSet Query.

You can also save queries, make queries you have saved available for other users to use, and transport queries, providing you have the relevant authorization.

Prerequisites

You are in the initial screen of InfoSet Query. Depending on how you have started InfoSet Query,

Procedure

  1. In the column Selection, select the relevant selection fields and, if necessary, remove the selection fields you do not need by clicking the relevant check box.

    2. The system transfers the selected fields to the selection field list. The selection fields that you have removed are no longer in the list.

  2. In the column Output, select the relevant output fields and, if necessary, remove the output fields you do not need by clicking the relevant check box.

    3. The system transfers the selected fields to the output preview. The output fields that you have removed are no longer in the output preview.

    You can also add the fields to the relevant area (selection or output area) using drag & drop. If you use drag and drop, you can insert the fields directly into the correct position in the output preview.

    Depending on the default settings, fields with texts have only their text or their value transferred when you select them by ticking the check boxes or by using drag & drop. However, you can also select fields by using the context menu of the relevant field. Here, you can choose whether you want to use the value, the text, or both.

  3. Enter the relevant selection values for the selection fields in the column Value.

    4. The value types (numeric, alphanumeric, date) that you can enter for the selection fields depend on the type of selection field.

  4. In the Options column, choose selection options (such as < or =).
  5. To execute the query, choose or Output.

Result

The query is executed. If you started it by choosing , the results list is displayed in the lower part of the screen. If you started it by choosing Output, the results list is displayed in full screen.

The default output works as follows; no selection screen is displayed and the specified selections are taken into account when outputting. You can, however, change these standard settings. You can find more information under Settings.

You can save the query, if you are authorized to do so. You can find more information under Saving Queries, Type of Reporting and Rights to Access InfoSet Query.