How to select data items

You can use the Data Items tab on the Queries/Reports -> Query/Report Generator screen to select which data items appear in a query or report. You must select at least one data item.

Alert: Location ID and Equipment ID Columns Expanded in the Database: Location ID columns have a maximum of 10 characters, and equipment ID columns have a maximum of 20 characters. Although the location ID and equipment ID fields throughout the GUI were expanded to the previously mentioned limits, standard reports in the Query/Report Generator were not changed to accommodate the expansion. If you use more than 6 characters for a location ID or 12 characters for an equipment ID, you will need to modify your reports to ensure that they display the full number of characters.

Note: Using a longer location ID may increase the size of part bar codes. If a part bar code is too long, it may run off the right side of the label and become unusable.
Tip: Before you run the conversion against your production data, make sure that you run a test conversion from your current version to 6.0.x. The conversion could take a long time to complete as these expansions affect several large tables. You will need to plan how much time to set aside for your production conversion.

To select which data items appear in a query or report:

Step 1. In the lower-left area of the tab, select the name of the table that contains the data items you want to include in the query or report. There is no limit to the number of tables you can include in a report; however, each table you choose (after the first table) must have a logical relationship or connection to one or more of the tables you chose previously.

Step 2. Click the Select button (or double-click the table name).

Note: If you need to select more than one table, you must use the Restrictions tab to specify a join rule for each additional table you select. Refer to Specifying a Join Rule.

All tables included in the query or report display in the lower center area of the tab.

Step 3. To display a list of the data items available in a table, double-click the table name or click the plus sign (+) to the left of the table name.

The joins command and the names of all data items in the table display beneath the table name. To hide these items, double-click the table name or click the minus sign [-] to the left of the table name.

Step 4. To display a data item's attributes, double-click the data item or click the + to the left of the data item.

Three attributes appear for each data item: type (alpha, numeric, variable characters), length, and number of decimal place. To hide the attributes, double-click the data item or click the minus sign [-] to the left of the data item.

Step 5. To add the data item to the query/report, select the data item and click the Select button (or double-click the column name).
The data item name displays in the lower right area of the tab.

Step 6. To display a list of a data item's default heading name, as well as its characteristics, double-click the data item or click the + to the left of the data item.

The default heading name and four characteristics display for each data item: field name, type (alpha, numeric, variable characters), length, and number of decimal places. (To hide the default heading name and attributes, double-click the data item or click the minus sign [-] to the left of the data item.)

Step 7. Repeat steps 1-6 for each table you want to include in the report.

Step 8. Continue to the other tabs on the Queries/Reports -> Query/Report Generator screen in order to continue defining the report, or go to the Manage tab to save, run, or perform a quick view query of the report.

_______________

How to select data items

See Also