Creating Queries

Prerequisites

You are in the initial screen of the Queries component.

Procedure

  1. Click on the Switch User Group icon to get to the User Groups dialog box. Choose the user group that you want the new query to belong to.
  2. Specify a name for the query.
  3. Choose Create.

    You get to a dialog box containing a list of the InfoSets that are assigned to the user group you have chosen.

    For more information on creating additional InfoSets, see Creating and Changing InfoSets.

  4. Select the InfoSet that is suitable for the new query. Choose Copy.

    If you have chosen an InfoSet, you get to the Create Query: Title, Format screen.

  5. Specify the required texts in the Title and the Description fields.

    You might need to change the settings under the following group headers:

    • List format

    • Table format

    • Output format

    • Special attributes

    • Print list

  6. Define your query in the sequences of screens designed for this purpose. Alternatively, you can use the Query Painter to define your basic list (see Creating Basic Lists with the Query Painter).

    There are sequences of screens for

    Within each of these sequences of screens, you have the following navigation options:

    • Click on the Next Screen and Previous Screen options to browse backwards and forwards.

    • Use the Back function to

      • get to the first screen in the sequence, if you are not already in this screen

      • another screen sequence, if you are in the first screen in the sequence.

    • The functions in the Goto menu take you directly to the individual screens in the current screen sequence or to the screens in another screen sequence.

    The following diagram shows the most important navigation options.

    In a query, you are able to define the following:

    • a basic list

    • up to nine statistics

    • up to nine ranked lists

    You can combine the various list types in any way that you like.

    You can also add sublists to existing queries.

    When you execute a query, in the list overview, you see by default the basic list first, followed by the statistics, and finally the ranked lists. You can adjust the sequence if you want to.