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.
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.
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.
To create a hyperlink to a screen for this field, click Add/Edit Hyperlinks.