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).

To define fields for grids:

  1. Open the Grid Designer form.
  2. Select the grid for which to add fields, and then click the Fields tab.
  3. Click Add Field.
  4. Field—Enter 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
  5. Alias—Enter 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.
  6. Header Location—Choose one of the following options to display a field in the header section above the grid:
    Note: 
    • None
    • Code
    • Description
    • Header 1
    • Header 2
    • Header 3
  7. Field Label—Enter the label for the field.
  8. Data Type—Choose one of the following options:
    • Upper Case
    • Mixed Case
    • Numeric
    • Date
    • Currency
    • Decimal
    • Date/Time
    • Duration
    • Time
    • Boolean
    • Long
    • Dependent
  9. Lookup Entity—Enter the entity used to populate the Dataspy lookup for the field. The system automatically populates entity description.
  10. Lookup Query—Enter the query used to populate the Dataspy lookup for the field. The system automatically populates Lookup Query Text.
  11. Grid Key—Select to identify the field as a key field for the grid.
  12. Click Submit.
    Note: To remove a Field for a grid, select the Field to remove, and then click Remove Field.

    To create a hyperlink to a screen for this field, click Add/Edit Hyperlinks. See Setting up hyperlinks.