Table: AO_3F6548_FIELDS_MAPPINGThe Table holds Mapping configuration data for issues field sync |
|---|
| Column | Description |
| DESTINATION_FIELD_ID varchar(255) | Admissible values for this field are: - null when the destination field is a comment or an attachment
- the description of the destination field when the field isn't a custom field or a Comment or an Attachment
- the string 'customfield_ ' & destination custom field id when the destination field is a custom field.
|
| DESTINATION_FIELD_NAME varchar(255) | The Destination field description. |
| ID int(11) AI PK | The Unique Field Mapping Identifier (Primary Key). |
| MAPPING_ID int(11) | The Mapping Identifier. |
| SOURCE_FIELD_ID varchar(255) | Admissible values for this field are: - 'Comment' or 'Attachment' when the source field is a comment or an attachment
- the description of the source field when the field isn't a custom field or a Comment or an Attachment
- the string 'customfield_ ' & source custom field id when the source field is a custom field.
|
| SOURCE_FIELD_NAME varchar(255) | The Source field description. |
| SYNC_DIRECTION varchar(255) | Admissible values for this field are: - SOURCE when sync direction is from source to target
- DESTINATION when sync direction is from target to source
- BOTH when sync direction works in both direction depending by the most recent update.
|
| SYNC_ENABLED tinyint(1) | When a new mapping is defined two field mappings for comments and attachments are automatically created having SYNC_ENABLED=0. Admissible values for this field are: - 0 when the field mapping isn't enabled
- 1 when the field mapping is enabled.
|
| SYNCH_ON_CREATE tinyint(1) | Admissible values for this field are: - '0' if Sync on create is set to False
- '1'if Sync on create is set to True (Not allowed for Assigee and Reporter)
- Null if Sync on create is not set (only Comments and Attachment) or due to Old Sync configuration (equal to False).
|
| NULL_ON_MISALIGNMENT | Admissible values for this field are: - '0' if Null on misalignment is set to Leave current value
- '1'if Null on misalignment is set to Null (Default for older configuration)
|