Mapping fields from Salesforce object to Jira Issue

Introduction

zAgileConnect supports field mapping from Case Fields to JIRA Issue fields (standard and custom).
The configuration for mapping may be found in the package Configuration page.

Screen-Shot-2015-09-01-at-5.36.27-PM.png
Screen-Shot-2015-09-01-at-5.36.48-PM.png

Notes

  • Since JIRA summary field is required, this field should be mapped to some compatible Case field during initial zAgileConnect setup

  • Please refer to the section below for compatibility in field mapping from Salesforce to Jira

  • Field mapping facilitates the following:

    • All mapped Issue fields are auto-populated during Issue Creation

    • Auto-creation of Issue from Case similarly uses the values from the mapped fields

    • Update issues using the values from the mapped fields.  zAgileConnect will update only the issues that were created from Salesforce Case.  Linked Issues do not support field mapping.

To ensure that a JIRA Issue field is available for mapping from Salesforce Issue Creation, please make sure that this Issue field is configured in JIRA’s Issue Creation screen.

Supported Issue Fields Types

Standard Fields

The following standard Jira Issue types are supported:

  • String (example: Summary, Description, Environment)

  • Component/s

  • Version/s (FixVersion/s, AffectsVersion/s)

  • Priority

  • Project

  • Issue Type

  • Date/DateTime (example: DueDate)

**Note: Issue Status may only be updated in Jira via workflow transitions

Custom Fields included in JIRA

The following custom fields types are supported:

TYPE

SCHEMA EXAMPLE

array

“schema“: {

  • “type“: “array”,

  • “items“: “string”,

  • “custom“:“com.atlassian.jira.plugin.system.customfieldtypes:multiselect”

},

schema“: {

  • “type“: “array”,

  • “items“: “string”,

  • “custom“:“com.atlassian.jira.plugin.system.customfieldtypes:multicheckboxes”

}

schema“: {

  • “type“: “array”,

  • “items“: “string”,

  • “custom“: “com.atlassian.jira.plugin.system.customfieldtypes:labels”

},

string

“schema“: {

  • “type“: “string”,

  • “custom“:“com.atlassian.jira.plugin.system.customfieldtypes:textarea”

}

“schema“: {

  • “type“: “string”,

  • “custom“:“com.atlassian.jira.plugin.system.customfieldtypes:textfield”

},

schema“: {

  • “type“: “string”,

  • “custom“: “com.atlassian.jira.plugin.system.customfieldtypes:select”

}

“schema“: {

  • “type“: “string”,

  • “custom“:“com.atlassian.jira.plugin.system.customfieldtypes:radiobuttons”

}

project

“schema“: {

  • “type“: “array”,

  • “items“: “project”,

  • “custom“: “com.atlassian.jira.plugin.system.customfieldtypes:project”

}

component/s

“schema“: {

  • “type“: “array”,

  • “items“: “component”,

  • “custom“: “com.atlassian.jira.plugin.system.customfieldtypes:component”

}

version/s

“schema“: {

  • “type“: “version”,

  • “custom“:“com.atlassian.jira.plugin.system.customfieldtypes:version”

},

schema“: {

  • “type“: “array”,

  • “items“: “version”,

  • “custom“:“com.atlassian.jira.plugin.system.customfieldtypes:multiversion”

}

priority

“schema“: {

  • “type“: “priority”,

  • “custom“: “com.atlassian.jira.plugin.system.customfieldtypes:priority”

}

date

“schema“: {

  • “type“: “date”,

  • “custom“:“com.atlassian.jira.plugin.system.customfieldtypes:datepicker”

}

number

“schema“: {

  • “type“: “number”,

  • “custom“: “com.atlassian.jira.plugin.system.customfieldtypes:float”

},

datetime

“schema“: {

  • “type“: “datetime”,

  • “custom“:“com.atlassian.jira.plugin.system.customfieldtypes:datetime”

}

Custom Fields added by Third-party plugins

Custom fields provided by Third-party plugins may be mapped only if those are derived from Standard Fields or Custom Fields included in Jira like: version, labels, issuetype, component, version[], issuetype[], labels[], component[], etc.

**Jira Agile fields (Sprint, Epic, etc) are currently not supported

Supported Case Fields Types

The following Field Types are supported by zAgileConnect:

TYPE FIELD VALUE

WHAT THE FIELD OBJECT CONTAINS

Boolean

Boolean (true or false) values. For example Checkbox Salesforce field

Currency

Currency values

Date

Date values

DateTime

DateTime values

Double

Double values

Email

Email addresses

ID

Primary key field for an object

Integer

Integer values

MultiPicklist

Multi-select picklists, which provide a set of enumerated values from which multiple values can be selected

Phone

Phone numbers. Values can include alphabetic characters. Client applications are responsible for phone number formatting.

Picklist

Single-select picklists, which provide a set of enumerated values from which only one value can be selected

String

String values

TextArea

String values that are displayed as multiline text fields

URL

URL values that are displayed as hyperlinks

Conversion from Salesforce Field Types to JIRA Issue Field Types

Case \ Issue

cascade select

textfield

textarea

labels

string

string[]

float

number

multicheckboxes

datepicker

datetime

date

select

multiselect

version

version[]

component

component[]

priority

priority[]

url

project

issuetype

Boolean (Checkbox)

cross mark

check mark

check mark

cross mark

check mark

cross mark

cross mark

cross mark

check mark (4)

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

Combobox


cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

Currency

cross mark

check mark

check mark

cross mark

check mark

cross mark

check mark

check mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

DataCategoryGroupReference


cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

Date

cross mark

check mark

check mark

cross mark

check mark

cross mark

cross mark

cross mark

cross mark

check mark

check mark (5)

check mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

Datetime

cross mark

check mark

check mark

cross mark

check mark

cross mark

cross mark

cross mark

cross mark

check mark

check mark

check mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

Double

cross mark

check mark

check mark

cross mark

check mark

cross mark

check mark

check mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

Email

cross mark

check mark

check mark

cross mark

check mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

EncryptedString


cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

ID


check mark

check mark

cross mark

check mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

Integer


check mark

check mark

cross mark

check mark

cross mark

check mark

check mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

MultipickList

cross mark

check mark

check mark

check mark

check mark

check mark

cross mark

cross mark

check mark

cross mark

cross mark

cross mark

check mark

check mark

check mark

check mark

check mark

check mark

check mark

check mark

cross mark

cross mark

cross mark

Percent

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

Phone

cross mark

check mark

check mark

cross mark

check mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

Picklist

cross mark

check mark

check mark

check mark

check mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

check mark

cross mark

check mark

cross mark

check mark

cross mark

check mark

cross mark

cross mark

check mark

check mark

Reference


cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

String (Text)

cross mark

check mark

check mark

check mark (7)

check mark

check mark

cross mark

cross mark

check mark

cross mark

cross mark

cross mark

check mark

check mark

check mark

check mark

check mark

check mark

check mark

cross mark

cross mark

check mark

check mark

TextArea

cross mark

cross mark

check mark

cross mark

check mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

Time


cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

URL

cross mark

check mark

check mark

cross mark

check mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

cross mark

check mark

cross mark

cross mark

Basic Types
  1. If the value is null it will be passed on as null

  2. From any type to String, TextField or TextArea is a direct conversion using String.valueOf().

  3. Numbers (Double, Integer, Decimal, Long, etc.) are converted to type double

  4. Boolean are converted to string values "true" or "false" when mapped to Text Jira fields.  However if the Jira field target is multicheckboxes and it has multiple items then only the first item will be selected/unselected

  5. Date is converted from Salesforce Date directly. For Datetime, it will take year, month and date, discarding any other value. The following format is used: yyyy-MM-dd

  6. Datetime is converted from Salesforce taking the following format: yyyy-MM-dd\’T\’HH:mm:ss.SZ

  7. String can be converted to JIRA labels, words are split with blank spaces.

Complex Types
  1. Salesforce’s  Picklist and MultipickList to JIRA String Array (string[]) – each value is taken and sent to JIRA as an item (PickList) or an array (MultipickList) of String.

  2. Salesforce’s  Picklist and MultipickList to JIRA array (priority[], component[], version[], etc.) — each item(s) is matched with name or value (project name, version name, component name, etc.) if these match then the id is added to the result.