Creating Basic Lists with the Query Painter

Use

Before it is able to create a new query, the system needs information that enables it to generate the corresponding report. The following entries are required:

• InfoSet

• Title and list format

• Field selection (fields used in the list)

• List layout

Prerequisites

You are in the initial screen of the Queries component.

Procedure

Proceed as follows to use the Query Painter to create a basic list:

1. Use the Switch User Group function to select the user group, to which you want the new query to belong.

2. Specify a name for the query.

3. Choose the Create function.

   A list of InfoSets belonging to the user group is displayed.

4. Select the InfoSet appropriate for your query and click on Accept .

   You are taken to the Create Query: Title, Format screen.

   To find out how to create InfoSets, see Creating and Changing InfoSets.

5. Type the appropriate information into the dialog fields.

6. Choose Settings  Settings to specify that you want to use the Query Painter to define the basic list.

7. In the Settings dialog box, activate the Graphical Query Painter check box and click on Continue .

   The Settings dialog box closes.

8. Click on the Basic List pushbutton to open the Query Painter. You can select the fields you want from the Query Painter directly.

   Alternatively, choose Next Screen , and choose the fields that you want to use to build your query before you start the Query Painter. This procedure is useful if you want to define local fields.

More Information

• See also: If you want to choose the fields in the Query Painter, see the section on Layout Mode/Graphical Query Painter.

• If you want to create local fields and add them to your query before you call the Query Painter, see the following sections:

  • Selecting Fields for Processing

  • Assigning Short Names

  • Defining Local Fields

  • Extending the Selection Criteria

• For more information, see Layout Mode/Graphical Query Painter.