The field editor enables you to:

• View the contents of a data source.
• Select the columns that can be used by widgets pointing to it.
• Check the type of each field, e.g. date, integer, etc. so that data can be correctly processed by widgets. 

Example

Field type in a CSV file containing the yearly number of incidents handled by Service Desk.

Notes

• Information on field types of EasyVista data sources is automatically retrieved from the database.
• By default, all of the data source columns are selected.
• In edit mode, only the first 15 data source records are displayed. In execute mode, all of the data source records are displayed.

• The names of data source columns are displayed in the logged-in user's language based on field names in the database.
• You can modify the names of data source columns. The customization will only apply to the current app.

• You can use different options for certain field types to narrow down the field.

  example  

  • Integer field ==>  Specify the thousands separator.
  • Date field ==>  Specify the date format.

Caution

• For CSV data sources, remember to specify delimiters for the downloaded file. This enables the field editor to read file data correctly.

  example  In the example below, the Column Separator Character property is specified. This property identifies the delimiter in the CSV file used to separate each row of data into columns.

Incorrect configuration		Correct configuration
Column Separator Character: ,   (comma) ==>   The editor displays a single column (all data source columns are concatenated)		Column Separator Character: ;   (semicolon) ==>   The editor displays the five columns in the file

Best Practice

• Check and correct if required the field type of the data source. The automatic detection may not work correctly for REST data sources or CSV files.

Access

In the Properties Inspector of a data source, click the button found below the Configure Field Types property

Screen description

The field editor is made up of two zones:

• (1) Left pane: List of fields available, not selected in the data source. These fields cannot be displayed in widgets pointing to the data source.
  • Move handle  above the field or radio button next to the field: Used to display a field in the data source by moving it to the right pane.

• (2) Right pane: Preview of the selected fields in the data source and the first 15 records of the data source. These fields can be displayed in widgets pointing to the data source.
  • Move handle  above the column header: Used to move the column within the table.
  • : Used to remove the field from the data source selection by moving it back to the left pane. You can also use its move handle .
  • : Used to modify the default name for the data source column header.
  • : Used to reset the data source column name and return to the default name.
  • Type: List of field types available. A list of additional options will automatically be displayed for certain field types.

Procedure: How to use the field editor

Step 1: Open the field editor for a data source.

1. Go to the data source you want.

The Properties Inspector will appear.

2. Click the button found below the Configure Field Types property.
The field editor will appear.
 

Step 2: Select the fields you want to use in the app.

1. Add the fields you want from the left pane.

• Click the radio button next to the field. It will automatically be positioned after the last data source column.
• You can also select the move handle  above the field name and move it to the relevant area in the right pane table.
           

2. Remove the fields you do not want from the right pane.

• Click  in the column header. It will automatically be moved in the left pane.
• You can also click the move handle  above the column header of the field and move it to the left pane.
           
   

Step 3: Define the properties of the fields.

Type of the fields

Name of the fields

Step 4: Arrange the columns in the right pane.

1. Click the move handle  above the column header of a field.

2. Move the column to the relevant area in the right pane table.
 

Step 5: Save the information.

1. Click OK.
The field editor will close. All widgets pointing to the data source will automatically be updated.