Defining fields for grids

Define fields for grids to modify the SELECT statement for the grid. Fields in the SELECT statement can be true fields or function calls (including parameters).

Select Administration > Setup > Grid Designer.
Select the grid for which to add fields, and then click the Fields tab.
Click Add Field.
Specify this information:
Field
Specify the field to add to the grid.
Note: Lookup Dataspies allow you to choose the following:

fields from the tables in the FROM clause

any fields in the whole database including any you created

functions
Alias

Specify the alias for the field.
Note: Field Alias can include only letters, numbers, and '_'. The same Field can be added twice if it appears in two different tables, but only with a different field alias each time.
Header Location
Choose one of the following options to display a field in the header section above the grid:
- None
- Code
- Description
- Header 1
- Header 2
- Header 3
Field Label

Specify the label for the field.
Data Type
Choose one of the following options:
- Upper Case
- Mixed Case
- Numeric
- Date
- Currency
- Decimal
- Date/Time
- Duration
- Time
- Boolean
- Long
- Dependent
Lookup Entity

Specify the entity used to populate the Dataspy lookup for the field. The system automatically populates entity description.

Lookup Query

Specify the query used to populate the Dataspy lookup for the field. The system automatically populates Lookup Query Text.

Grid Key

Select to identify the field as a key field for the grid.
Click Submit.

Note: To create a hyperlink to a screen for this field, click Add/Edit Hyperlinks.