Herzum Quick Linker Documentation
Page tree

Versions Compared

Old Version 22

changes.mady.by.user Antonella Capalbo

Saved on

compared with

New Version 23

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' or Null if Sync on create is set to False
  • '1'if Sync on create is set to True (this setting is not allowed for Assigee and Reporter)
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.
SYNCH_AUTOR tinyint(1)

Admissible values for this field are:

  • '0' if  Synch Comment Author is set to False (Default )
  • '1' if Synch Comment Author is set to True
 SYNCHRESTRICTIONVISIBILITY_RESTRICTION_VISIBILITY

Admissible values for this field are:

  • '0' if  Synch Restriction Visibility is set to False (Default )
  • '1' if Synch Restriction Visibility is set to True

...

Table: AO_3F6548_MAPPING_PATTERN    

The Table holds the Mapping Patterns

ColumnDescription

HQL_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.
ID int(11) AI PK The Unique Mapping Pattern Identifier (Primary Key)
ISSUE_LINK_TYPE bigint(20)Identifier of the JIRA issue Link.
LABEL varchar(255)The Button label.
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
PARTNERSHIP_ID int(11)The Partnership Identifier.
SOURCE_ISSUE_TYPE varchar(255)The "from" Issue Type Identifier.
SYSTEM_USER_CREDENTIAL tinyint(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
TARGET_ISSUE_TYPE varchar(255)The "to" Issue Type Identifier.
LINK_ACTIONS varchar(255)

Admissible values for this field are:

  • 'CreateLinkingPlusLinkExisting' the Create&Linking button and Link Existing button are all two displayed (Default)
  • 'CreateLinking' the Create&Linking button is displayed exclusively
  • 'LinkExisting'' the Link Existing button is displayed exclusively
 SYNCH_RESTRICTION_VISIBILITY

Admissible values for this field are:

  • '0' if  Synch Restriction Visibility is set to False (Default )
  • '1' if Synch Restriction Visibility is set to True

Table:  AO_3F6548_PERMISSIONS 

The Table holds Permissions

ColumnDescription

ENTITY varchar(255)

Admissible values for this field are:

  • Quick Links
  • Quick Actions
ID int(11) AI PK The Unique Permission Identifier (Primary Key)

ISSUE_TYPE_ID varchar(255)

The issue type Identifier

PROJECT_ID bigint(20)

The project Identifier
TYPE varchar(255)

Admissible values for this field are:

  • Users 

  • Groups 

  • Roles 

  • Reporter 

  • Assignee 

  • Project Lead

  • Denied
VALUE varchar(255)

Admissible values for this field are:

  • an user username
  • a Group name
  • a Project Role

  • Reporter 

  • Assignee 

  • Project Lead

  • All