Selecting Output Fields for Queries and Reports

The Select Output Fields screen specifies the fields to appear in a query and the order in which they appear in each record.

The screen appears in the process of adding or modifying queries, as shown in Adding and Modifying Queries.

​                             ​ Select​ Output​ Fields​                                                                                                                ​ Query  . . . . .​ TESTJZ    ​ Test for Documentation                            ​  ​ Entry  . . . . .​ 00​        ​ Generic entry type (00-99 for reporting only)     ​                                          ​ Find (F16).​                          ​                                                                                                                                                           ​ Output​     ​ Seq.​  ​ Description​                                      ​ Attribute​  ​ Length​   ​  ​   1.0​ ​ Date & Time   yyyy-mm-dd-hh.mm                    ​    19​ A​   ​    19​      ​   2.0​ ​ Name of job                                       ​    10​ A​   ​    10​      ​   3.0​ ​ User of job                                       ​    10​ A​   ​    10​      ​      ​ ​ Number of job                                     ​     6​ A​   ​     6​      ​      ​ ​ Current user profile                              ​    10​ A​   ​    10​      ​      ​ ​ System name                                       ​     8​ A​   ​     8​      ​      ​ ​ Object                                            ​    10​ A​   ​    10​      ​      ​ ​ Object library                                    ​    10​ A​   ​    10​      ​      ​ ​ Object type                                       ​     7​ A​   ​     7​      ​      ​ ​ User                                              ​    18​ A​   ​    18​      ​      ​ ​ *FYI mode (simulation)                            ​     1​ A​   ​     1​                                                                      ​      More...​  ​ Pink fields are generic (all types)​  ​ Green fields apply to this type only ​     ​ F3=Exit  F5=Display values  F12=Cancel​ ​ F16=Find​ ​  F21=Select all  F23=Invert​                                                                                    ​                                                                             ​  ​  ​

The read-only Query field shows the name and description of the query.

The read-only Entry field shows the code and description of the entry type that the query processes.

The body of the screen contains one line for each field defined for the entry type specified for the query (shown in green) as well as one for each of several generic fields that do not depend on the entry type (shown in pink).

Each contains the following fields:

Seq.

A number determining the order in which the fields appear. For example, fields with the Seq values 1.0, 1.1, 2.0, 4.0 would appear in that order, regardless of the order in which they appear in the displayed list.

Description

A read-only text description of the field, as defined for that entry type or generic field.

Attribute

A pair of read-only fields showing the length and type of the field, as defined for that entry type or generic field.

Output Length

The number of characters allocated for the field contents in the output.

To find a field in the list, enter a string from the field name in the Find field and press the F16 (Shift+F4) key. The cursor moves from the current field to the next field with a name that includes that string. If there are no more field names containing the string in the rest of the list, it searches from the beginning.

To select all fields, press the F21 (Shift+F9) key.

To invert the selection, selecting all fields that are not currently selected and deselecting those that are, press the F23 (Shift+F11) key.