Herzum Quick Linker Documentation
Page tree

Versions Compared

Old Version 17

changes.mady.by.user Antonella Capalbo

Saved on

compared with

New Version 18

changes.mady.by.user Antonella Capalbo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table: AO_3F6548_FIELDS_MAPPING

The Table holds Mapping configuration data for issues field sync

ColumnDescription
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 (Comments and Attachment) or due to Old Sync configuration (equal to False).
NULL_ON_MISALIGNMENT tinyint(1) 

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)
MAPPING_PATTERN_ID int(11) The Mapping Pattern Identifier.

SOURCE_CF_TYPE varchar(255) 

Admissible values for this field are:

  • 'select' if the source field is a Select list (single choice) or a Radio button
  • 'multiSelect' if the source field is a Select list (multiple choice) or a Check box.
  • Null for all other settings.
DESTINATION_CF_TYPE varchar(255) 

Admissible values for this field are:

  • 'select' if the target field is a Select list (single choice) or a Radio button
  • 'multiSelect' if the target field is a Select list (multiple choice) or a Check box.
  • Null for all other settings.

The Table holds Issue Link data

ColumnDescription
DESTINATION_ISSUE_ID bigint(20) The Identifier of the destination Issue.  
ID int(11) AI PK The Unique Issue Link Identifier (Primary Key).
JIRA_LINK_TYPE varchar(255) The  Identifier of the JIRA Link Type.
LINK_TYPE varchar(255) Admissible values for this field are:
INTERNAL when the target instance is the current instance
REMOTE when the target instance is a remote instance.
MAPPING_ID int(11) The Mapping Identifier.
SOURCE_ISSUE_ID bigint(20)The Identifier of the source Issue.  
RANK_DIN_S int(11) Maintain the issue ranking source side
RANK_SIN_S int(11) Maintain the issue ranking target side
IS_JIRA_LINK tinyint(1) 

Admissible values for this field are:

  • '1' if the link isJIRA link type
  • '0' if the link isQuick link type or Both
LINK_VERSUS_OUT_IN tinyint(1) 

Admissible values for this field are:

  • '1' if selected Link versus is Outward/Inward (Default)
  • '0' if selected Link versus is Inward/Outward

...