Defining fields for grids - HxGN EAM - 12.0.1 - Help - Hexagon

HxGN EAM Help

Language
English
Product
HxGN EAM
Search by Category
Help
HxGN EAM Version
12.0.1

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

  1. Select Administration > Setup > Grid Designer.

  2. Select the grid for which to add fields, and then click the Fields tab.

  3. Click Add Field.

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

  5. Click Submit.

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