Herzum Quick Linker Documentation
Page tree

Versions Compared

Old Version 14

changes.mady.by.user Antonella Capalbo

Saved on

compared with

New Version 15

changes.mady.by.user Antonella Capalbo

Saved on

Key

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

...

Table: AO_3F6548_MAPPING

The Table holds Mapping configuration data

ColumnDescription
CONFIG_ID int(11) Not used. This field supports migration from older versions.
CUSTOM_FIELD_MAPPING varchar(255) Not used. This field supports migration from older versions.
DESTINATION_ISSUE_TYPE varchar(255) The "to" Issue Type Identifier.
DESTINATION_PRIORITY varchar(255) The priority Identifier for issues created by the escalation post function.
DESTINATION_PROJECT varchar(255) The "to" JIRA Project Identifier.
POPUP_ENABLED tyniint(1)Not used. This field supports migration from older versions.
FIELDS varchar(255) Not used. This field supports migration from older versions.
HAS_QLFUNCTION tinyint(1) 

Admissible values for this field are:
'0' if Quick Action Button/Post Function isn't flagged
'1' if Quick Action Button/Post Function is flagged.

ID int(11) AI PK The Unique Mapping Identifier (Primary Key).
LABEL varchar(255)The Button label.
LINK varchar(255) Identifier of the JIRA issue Link.
LINK_TYPE varchar(255)

Admissible values for this field are:

  • 'Both' if selected Link Type is both
  • 'Quick Link' if selected Link Type is Quick Link
  • 'JIRA Link' if selected Link Type is JIRA Link.
PARTNERSHIP_ID int(11) The Partnership Identifier.
REMOTE_MAPPING_ID int(11) The Remote Mapping Identifier.
SOURCE_ISSUE_TYPE varchar(255) The "from" Issue Type Identifier.
SOURCE_PROJECT varchar(255)The "from" JIRA Project Identifier.
LINK_VERSUS_OUT_IN tyniint(1)

Admissible values for this field are:

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

Admissible values for this field are:

  • '1' If Allow issue creation/linking via partnership credentials is set to False (Default)
  • '0' If Allow issue creation/linking via partnership credentials is set to True
SCHEMA_PATTERN_REL_ID int(11) Identifier of the SchemaScheme/Pattern relationassociation.

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.

...

Table: AO_3F6548_SCHEME_PATTERN_REL 

The Table holds the associations between Schemas Schemes and Mapping Patterns

ColumnDescription
ID int(11) AI PK         The Unique Mapping Pattern/Schema Scheme association Identifier (Primary Key)              
MAPPING_PATTERN_ID int(11)The Mapping Pattern Identifier 
MAPPING_SCHEME_ID int(11)The Mapping Schema Scheme Identifier 

Table: AO_3F6548_PROJECT_SCHEME_REL  

The Table holds the associations between Schemas Schemes and Projects

ColumnDescription
ID int(11) AI PK         The Unique Mapping SchemaScheme/Project association Identifier (Primary Key)
MAPPING_SCHEME_ID int(11)The Mapping Schema Scheme Identifier
PROJECT_ID bigint(20)The Project Identifier

Table: AO_3F6548_MAPPING_SCHEME   

The Table holds the Mapping Schemes

ColumnDescription
ID int(11) AI PK         The Unique Mapping Scheme Identifier (Primary Key)

SCHEME_DENOMINATION varchar(255)

The Mapping Scheme denomination

Table: AO_3F6548_MAPPING_PATTERN    

The Table holds the Mapping Patterns

ColumnDescription