Show TOC

Creating QueriesLocate this document in the navigation structure


You are in the initial screen of the Queries component.


  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.

    The name of the query

    • can be up to 14 characters long

    • must appear in a user group only once

  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.

    There are various search functions that you can use to find the right InfoSet from a large number of InfoSets with many fields.

    • Find. Specify the name or description of the InfoSet that you want to find. The system searches list of InfoSets.

    • InfoSet Search Specify a field name or a table name. The system searches the list of InfoSets.

    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.