Display fields

Owned by Dorian Port
Last updated: Sept 05, 2014 by Paul Sugg

When a server is first deployed, the default presentation layer includes the same fields that were displayed in the V9 server (User, Pin, Field Value, Language, Cad status/received and Device name/version:

Adding and removing columns

To alter the values, click on the presentation layer icon and select the 'Display fields' tab.  The available fields are listed in the left hand column and includes fields in the current database table (and related tables where possible).  The fields that are currently in use are displayed in the column on the right of the screen:

To add columns to the display, select in the left hand column and click on the right arrow to include in the current presentation configuration.  To remove fields, select in the right hand column and select the left arrow icon to move back to the available columns field.  The order can be sorted by highlighting a field in the right hand column and moving up / down.

Combining fields

You can display two or more fields in one column (for example Cad received date and Cad version) by selecting two fields and adding them both together.  To select two fields to group together:

  1. Select the first column in a list (for example CADRECVDON)
  2. Hold down the ALT key (command on Mac) and select a second column (CADVERSIONNAME)
  3. Select the right arrow to move selections to the right and a popup screen will be displayed asking you to enter a Label and Delimiter.  The label will be displayed at the top of the column, the Delimiter will be inserted between the data returned in a list
  4. You can reorder the sequence in which fields are listed by moving up/down in the list of fields being combined by selecting a field and using the up/down arrows to move.  Fields at the top of the list are ordered first (within the same column)
  5. Select OK to save

The following screen shows us adding the CADRECVDON and CADVERSIONNAME together to create a combined field.  It is then labelled "Cad date/version" and we are using "|" as a delimiter:

This will add a Cad date/version column to the Users screen with the date that a Cad was received and the Cad version name (in this case V1).  Data returned is separated with the delimiter selected:

Label options

In addition to choosing which columns are displayed and being able to combine columns and change the order that they are displayed, users can also change the label at the top of each column, to alter the label:

  1. Select the Presentation configuration icon
  2. Select the field you wish to change the label for in the right hand column
  3. The label used is displayed, Type a new value in the 'Label' field
  4. Select 'Update' in the same window as the label field
  5. Save your changes and exit the Presentation configuration by selecting the 'Save' button in the top left of the screen

If you do not select 'Update' in the window when changing 'Label' or 'Type' before selecting 'Save' to exit the presentation configuration, your changes will be lost

Type options for date fields

Datetime fields can sometimes be displayed in the incorrect value for your country dd/mm/yyyy instead of mm/dd/yyyy.  Sometimes, the time is also displayed in seconds since epoch.  You can adjust the format of the date and time displayed by performing the following:

  1. Select the Presentation configuration icon
  2. Select the field you wish to change the format of
  3. In the 'Type' dropdown selection box, select 'Date'
  4. Enter the format of your date
  5. Select 'Update' in the same window as the 'Type' window
  6. Save your changes and exit the Presentation configuration by selecting the 'Save' button in the top left of the screen

When formatting date time fields, they are split into the following components.  Including/excluding these values will control what is displayed in the console:

hh - Hours

mm - Minutes (lowercase)

ss - Seconds

dd - Day

MM - Month (uppercase)

yyyy - Year

Optional Terms:

Delimiter - please specify the delimiter used to separate the items above, such as : - /

a - displays am / pm.  If this is not included, dates and times will still be displayed in am/pm format, but without the am/pm indicator, therefore it is recommended that this is added always.

Sample formats:  (hh:mm:ss a dd/MM/yyyy) (MM-dd-yyyy hh:mm:ss a)

Type options for status fields

You may choose to display a different value to that saved in the database.  This is used in a similar way to keywords in the console, where the value you want to display to your administrator is different to that stored in the database.  One example of such a field is ISDEVDEVICE, which is used to denote whether a device is a development device.  In the database, this is stored as a 0 (false) or 1 (true) value, but displaying 0 or 1 to an administrator has little value, so you can format the results for this column to display "Yes" if 1 is stored or "No" of 0 is stored against a user.

To change which values are displayed:

  1. Select the Presentation configuration icon
  2. Select the field you wish to change the format of (for example ISDEVDEVICE)
  3. In the 'Type' dropdown selection box, choose 'Select'
  4. A new option is displayed "Pick list mapping".  One row is added, enter the value you wish to display to a user in the left hand box (Such as "Yes")
  5. Enter the value that is stored in the database in the right hand box.  For example, if you want "Yes" to be displayed if "1" is found, enter 1.
  6. To add more values, click on the + icon to add more rows, the - icon will remove a row.  In the example give, you would want to add a value for "No" and "0"
  7. Select 'Update' in the same window as the Type selection box
  8. Select 'Save' button in top left of the screen

The following screen would indicate the correct mapping if instead of displaying 1/0 onscreen, Yes/No is displayed:

Now, whenever results are displayed on screen for the ISDEVDEVICE screen, when the console is retrieving details from the database, if "1" is found, it is displayed as "Yes" onscreen.

You must select 'Update' before selecting 'Save' otherwise your changes will be lost