User Guide : Managing Schema : Exploring Schema Editor : Managing Fields in Records
 
Share this page             
Managing Fields in Records
You can add, delete, or reorder the fields in a record.
Adding Fields to a Record in JSON Schema
To add fields to a record, in the left pane, expand the tree and click the required record node (example, R1) and then click /download/attachments/25954037/Map_Source_Add_Icon.png?version=1&modificationDate=1493578526312&api=v2. A field is added to the grid and displays the following columns.
To insert a field in the middle of a field list, select the row before which you want to add the field and click /download/attachments/24975466/Map_Mapping_AddField_Icon.png?version=1&modificationDate=1487964384147&api=v2. A new field will be added before the selected row. If no row is selected, then the new field is added to the end of the field list. If all fields are selected and you insert a new field, the new field will be inserted at the end of the field list.
The same behavior occurs when you right-click and select Add Field or when you use the <Insert> key.
 
Column Name
Description
Field
Name of the field. To change the name, click the name and type the required name.
Description
Description about the field. Click within cell and type a description.
Type
From the drop-down list, select the required data type.
Note:  Only connectors that support record hierarchy has the Record data type available.
Size
From the drop-down list, select the data type size.
Properties
Click /download/attachments/25954037/Map_Mapping_PropertiesIcon.png?version=1&modificationDate=1493578526296&api=v2 or right-click on the row for which you want to specify the field properties, and click Properties. The Field Properties window is displayed. You can specify the following properties for a field:
Field Required - Select Yes if the field is required. Else, select No.
Default Expression - Edit directly in the cell or click ... to open the Expression Editor.
Abstract - Select Yes if the field is required. Else, select No.
SQL Literal - Select Yes if the field is required. Else, select No.
Min occurrence - Select any of the following:
0
1
2
Max occurrence - Select any of the following:
0
1
2
Unbounded
Default Value
Data Type - Select the required data type. Based on the selected data type, the properties are displayed.
Deleting Fields in a Record in JSON Schema
To delete a field in the record:
1. In the left pane, expand All Record Types.
2. Click the required record for which you want to delete a field and click /download/attachments/25954037/Map_Mapping_DeleteField_Icon.png?version=1&modificationDate=1493578526202&api=v2.
To delete multiple fields, press the Ctrl key and select the required fields or press the Shift key and select a range of fields, and then click /download/attachments/25954037/Map_Mapping_DeleteField_Icon.png?version=1&modificationDate=1493578526202&api=v2.
A message asking for confirmation is displayed.
3. Click Yes.
The selected field(s) are deleted.
Reordering Fields in a Record in JSON Schema
To reorder the fields in a record:
1. In the left pane, expand All Record Types.
2. Click the required record node for which you want to reorder the fields.
3. In the right-pane grid, select the field that you want to move and click /download/attachments/25954037/Map_Source_UpArrow_Icon.png?version=1&modificationDate=1493578526343&api=v2 to move the field(s) up or click /download/attachments/25954037/Map_Source_DownArrow_Icon.png?version=1&modificationDate=1493578526327&api=v2 to move the field(s) down.
To move multiple fields, press the Ctrl key and select the required fields or press the Shift key and select a range of fields, and then click /download/attachments/25954037/Map_Source_UpArrow_Icon.png?version=1&modificationDate=1493578526343&api=v2 or /download/attachments/25954037/Map_Source_DownArrow_Icon.png?version=1&modificationDate=1493578526327&api=v2.
Adding Fields to a Record in XML Schema
To add fields to a record, in the left pane, expand the tree and click the required record node (example, R1). In the right-pane, click /download/attachments/25954037/Map_Source_Add_Icon.png?version=1&modificationDate=1493578526312&api=v2. A field is added to the grid and displays the following columns.
To insert a field in the middle of a field list, select the row before which you want to add the field and click /download/attachments/24975466/Map_Mapping_AddField_Icon.png?version=1&modificationDate=1487964384147&api=v2. A new field will be added before the selected row. If no row is selected, then the new field is added to the end of the field list. If all fields are selected and you insert a new field, the new field will be inserted at the end of the field list. The same behavior occurs when you right-click and select Add Field or when you use the <Insert> key.
 
Column Name
Description
Field
Name of the field. To change the name, click the name and type the required name.
Description
Description about the field. Click within cell and type a description.
Type
From the drop-down list, select the required data type.
Note:  Only connectors that support record hierarchy has the Record data type available.
Size
From the drop-down list, select the data type size.
Properties
Click /download/attachments/25954037/Map_Mapping_PropertiesIcon.png?version=1&modificationDate=1493578526296&api=v2 or right-click on the row for which you want to specify the field properties, and click Properties. The Field Properties window is displayed. You can specify the following properties for a field:
Field Required - Select Yes if the field is required. Else, select No.
Default Expression - Edit directly in the cell or click ... to open the Expression Editor.
Data Type - Select the required data type. Based on the selected data type, the properties are displayed.
Deleting Fields in a Record in XML Schema
To delete a field in the record:
1. In the left pane, expand All Records and click the required record node for which you want to delete a field.
2. In the right-pane, select the field that you want to delete and click /download/attachments/25954037/Map_Mapping_DeleteField_Icon.png?version=1&modificationDate=1493578526202&api=v2.
To delete multiple fields, press the Ctrl key and select the required fields or press the Shift key and select a range of fields, and then click /download/attachments/25954037/Map_Mapping_DeleteField_Icon.png?version=1&modificationDate=1493578526202&api=v2.
A message asking for confirmation is displayed.
3. Click Yes.
The selected field(s) are deleted.
Reordering Fields in a Record in XML Schema
To reorder the fields in a record:
1. In the left pane, expand All Records and click the required record node for which you want to reorder the fields.
2. In the right-pane, select the field that you want to move and click /download/attachments/25954037/Map_Source_UpArrow_Icon.png?version=1&modificationDate=1493578526343&api=v2 to move the field(s) up or click /download/attachments/25954037/Map_Source_DownArrow_Icon.png?version=1&modificationDate=1493578526327&api=v2 to move the field(s) down.
To move multiple fields, press the Ctrl key and select the required fields or press the Shift key and select a range of fields, and then click /download/attachments/25954037/Map_Source_UpArrow_Icon.png?version=1&modificationDate=1493578526343&api=v2 or /download/attachments/25954037/Map_Source_DownArrow_Icon.png?version=1&modificationDate=1493578526327&api=v2.
3. Save the changes.