SQL Connector for Jira (Cloud)
Breadcrumbs

Fields Mapping

check mark available

minus not available

🛠 in development and/or on our product roadmap

Jira Work Management (former Jira Core)

Functionality

Data center

Cloud

Notes and How-To

Issues

Issue ID

check mark

check mark

 

Issue Key

check mark

check mark

 

Issue Type Id

check mark

check mark

 

Issue Type Name

check mark

check mark

 

Resolved

check mark

check mark

On Cloud similar to 'Resolution Date'

Resolution / Resolution Date

check mark

check mark

 

Due Date

check mark

check mark

 

Description

check mark

check mark

 

Current Status Id

check mark

check mark

 

Current Status Name

check mark

check mark

 

Current Status Category Name

check mark

check mark

On Cloud can be retrieved from the 'Issue Statuses' section

Status Changed Date

check mark

check mark

On Cloud can be retrieved from the 'Time in Status' section

Status Category Changed Date

check mark

check mark

 

Current Assignee (ID/Key, Name)

check mark

check mark

 

Reporter (ID/Key, Name)

check mark

check mark

 

Creator (ID/Key, Name)

check mark

check mark

 

Project Id

check mark

check mark

 

Project Key

check mark

check mark

 

Priority

check mark

check mark

 

Security Level

check mark

check mark

 

Created

check mark

check mark

 

Updated

check mark

check mark

 

Last Viewed

check mark

check mark

 

Environment

check mark

check mark

 

Summary

check mark

check mark

 

Time at Current Assignee in hours

check mark

check mark

On Cloud can be retrieved from the 'Time in Status' section

Time at Current Assignee in days, decimal

check mark

check mark

On Cloud can be retrieved from the 'Time With Assignee' section

Time at Current Assignee in days, rounded

check mark

check mark

 

Watchers

check mark

check mark

 

Votes

check mark

check mark

 

Work Ratio

check mark

check mark

 

Issue Effort

Time Spent

check mark

check mark

 

Time Spent Including Sub-Tasks

check mark

check mark

 

Original Estimate

check mark

check mark

 

Original Estimate Including Sub-Tasks

check mark

check mark

 

Remaining Estimate

check mark

check mark

 

Remaining Estimate Including Sub-Tasks

check mark

check mark

 

Business Time Spent

minus

check mark

 

Business Time Spent Including Sub-tasks

minus

check mark

 

Business Original Estimate

minus

check mark

 

Business Original Estimate Including Sub-tasks

minus

check mark

 

Business Remaining Estimate

minus

check mark

 

Business Remaining Estimate Including Sub-tasks

minus

check mark

 

Issue Worklogs

Worklog Issue Key / Issue Key

check mark

check mark

 

User (ID/Key, Name)

check mark

check mark

 

Date / Start Date

check mark

check mark

 

Description

check mark

check mark

 

Creation Date / Created

check mark

check mark

 

Logged Time

check mark

check mark

 

Issue Id

check mark

check mark

 

User is Active

check mark

check mark

On Cloud can be retrieved from the 'Users' section

Username / Author Name

check mark

check mark

 

User Email

check mark

check mark

On Cloud can be retrieved from the 'Users' section

User Timezone

check mark

check mark

On Cloud can be retrieved from the 'Users' section

Update Date / Updated

check mark

check mark

 

Worklog ID

minus

check mark

 

Updater ID

minus

check mark

 

Updater Name

minus

check mark

 

Tempo Billable Time

minus

check mark

 

Issue Statuses

Name / Issue Status Name

check mark

check mark

 

Sequence

check mark

minus

 

Description

check mark

check mark

 

Icon URL

check mark

check mark

 

Status Category / Category

check mark

check mark

 

Issue Status ID

minus

check mark

 

Scope Type

minus

check mark

 

Scope ID

minus

check mark

 

Issue Types

Name / Issue Type Name

check mark

check mark

 

Sequence

check mark

minus

 

Description

check mark

check mark

 

Issue Type ID

minus

check mark

 

Is Sub-task?

minus

check mark

 

Icon URL

minus

check mark

 

Scope Type

minus

check mark

 

Scope ID

minus

check mark

 

Issue Links

Linked Issues / Issue ID

check mark

check mark

 

Link Type / Type

check mark

check mark

 

Issue Key

check mark

check mark

 

Link Direction / Direction

check mark

check mark

 

Linked Issue ID

minus

check mark

 

Linked Issue Key

check mark

check mark

 

Issue Attachments

Attachment Id

minus

check mark

 

Attachment Issue Key / Issue Key

check mark

check mark

 

Attachment Issue Id / Issue ID

check mark

check mark

 

Attachment FileName

check mark

check mark

 

Attachment FileSize

check mark

check mark

 

Attachment MimeType

check mark

check mark

 

Attachment Is ZIP

check mark

minus

 

Attachment Date Created

check mark

check mark

 

Attachment User Key / Author ID

check mark

check mark

 

Attachment User Name / Author Name

check mark

check mark

 

Thumbnail

minus

check mark

 

Content

minus

check mark

 

Issue Remote Links

Issue Id

check mark

minus

 

Issue Key

check mark

minus

 

Title

check mark

minus

 

URL

check mark

minus

 

Summary

check mark

minus

 

Icon URL

check mark

minus

 

Icon Title

check mark

minus

 

Resolved

check mark

minus

 

Application Type

check mark

minus

 

Application Name

check mark

minus

 

Relationship

check mark

minus

 

Status Name

check mark

minus

 

Status Description

check mark

minus

 

Issue Labels

Labels Issue Key / Issue Key

check mark

check mark

 

Labels Issue Id / Issue Id

check mark

check mark

 

Labels Name / Name

check mark

check mark

 

Issue Comments

Issue Id

check mark

check mark

 

Issue Key

check mark

check mark

 

Comment

check mark

check mark

 

Created

check mark

check mark

 

Author Key / Author ID

check mark

check mark

 

Author Name

check mark

check mark

 

Comment ID

minus

check mark

 

Updated

minus

check mark

 

Updater ID

minus

check mark

 

Updater Name

minus

check mark ​​

 

Parent Issues

Parent Issue Key

check mark

check mark

 

Parent Issue Status Id / Parent Issue Id

check mark

check mark

 

Parent Issue Status Name

check mark

check mark

On Cloud can be retrieved from the 'Issues' section

Parent Issue Status Category Name

check mark

check mark

Parent Issue Type Id

check mark

check mark

Parent Issue Type Name

check mark

check mark

Parent Issue Summary

check mark

check mark

Parent Issue Priority

check mark

check mark

Sub-Tasks

Issue Key

check mark

check mark

You can use 'Is Sub-Task?' field in the 'Issue Types' section on Cloud instead

Sub-Tasks

check mark

minus

 

Histories

History Field / Field

check mark

check mark

 

History Author ID

check mark

check mark

 

History Author Name

minus

check mark

 

History New Value / New Value

check mark

check mark

 

History Old Value / Old Value

check mark

check mark

 

History New Value Name / New Value Formatted

check mark

check mark

 

History Old Value Name / Old Value Formatted

check mark

check mark

 

History Issue Key / Issue Key

check mark

check mark

 

History Issue Id / Issue Id

check mark

check mark

 

History Created / Created

check mark

check mark

 

Time in Statuses

History Status

check mark

minus

 

Time in Status in hours / Duration in 24/7

check mark

check mark

 

Time in Status in days

check mark

minus

 

Time in Status in business hours

check mark

minus

 

Time in Status in business days / Duration in Business Days (24/5)

check mark

check mark

 

Status Start

check mark

minus

 

Status End

check mark

minus

 

Issue ID

minus

check mark

 

Issue Key

minus

check mark

 

Status ID

minus

check mark

 

Status Name

minus

check mark

 

Formatted Duration in 24/7

minus

check mark

 

Formatted Duration in Business Days (24/5)

minus

check mark

 

Duration in Business Hours/Days (8/5)

minus

check mark

 

Formatted Duration in Business Hours/Days (8/5)

minus

check mark

 

Issue in Status Count

minus

check mark

 

First Transition To Status

minus

check mark

 

Last Transition To Status

minus

check mark

 

First Transition From Status

minus

check mark

 

Last Transition From Status

minus

check mark

 

Time at Assignee / Time With Assignee

Assigned person / User Name

check mark

check mark

 

Time at Assignee in hours / Duration in 24/7

check mark

check mark

 

Time at Assignee in days

check mark

minus

 

Time at Assignee in business hours

check mark

minus

 

Time at Assignee in business days / Duration in Business Days (24/5)

check mark

check mark

 

Assignee Start

check mark

minus

 

Assignee End

check mark

minus

 

Assignee Sequence

check mark

minus

 

Assignee With Sequence

check mark

minus

 

Is Current Assignee

check mark

minus

 

Issue ID

minus

check mark

 

Issue Key

minus

check mark

 

User ID

minus

check mark

 

Formatted Duration in 24/7

minus

check mark

 

Formatted Duration in Business Days (24/5)

minus

check mark

 

Duration in Business Hours/Days (8/5)

minus

check mark

 

Formatted Duration in Business Hours/Days (8/5)

minus

check mark

 

Projects

Project Lead / Project Lead ID

check mark

check mark

 

Project Lead Name

check mark

check mark

 

Project Lead Email

check mark

check mark

On Cloud can be retrieved from the 'Users' section

Project Category / Category

check mark

check mark

 

Project Name / Name

check mark

check mark

 

Project Key

check mark

check mark

 

Project Description / Description

check mark

check mark

 

Project Type / Type

check mark

check mark

 

Permission Scheme ID

check mark

minus

 

Permission Scheme Name

check mark

minus

 

Project ID

minus

check mark

 

URL

minus

check mark

 

Style

minus

check mark

 

Is Private?

minus

check mark

 

Total Issue Count

minus

check mark

 

Last Issue Update Time

minus

check mark

 

Is Archived?

minus

check mark

 

Archived Date

minus

check mark

 

Archived By ID

minus

check mark

 

Archived By Name

minus

check mark

 

Is Deleted?

minus

check mark

 

Deleted Date

minus

check mark

 

Retention Till Date

minus

check mark

 

Deleted By ID

minus

check mark

 

Deleted By Name

minus

check mark

 

Fix Versions / Versions + Issue Fix Versions

Fix Version Issue Key / Issue Key

check mark

check mark

 

Fix Version Issue Id / Issue Id

check mark

check mark

 

Fix Version Archived / Is Archived?

check mark

check mark

 

Fix Version Description / Description

check mark

check mark

 

Fix Version Name / Version Name

check mark

check mark

 

Fix Version Release Date / Release Date

check mark

check mark

 

Fix Version Start Date / Start Date

check mark

check mark

 

Fix Version Released / Is Released?

check mark

check mark

 

Version ID

minus

check mark

 

Version Name

minus

check mark

 

Is Overdue?

minus

check mark

 

Project ID

minus

check mark

 

Project Key

minus

check mark

 

Description

check mark

check mark

 

Affect Versions / Issue Affect Versions

Affects Version Issue Key / Issue Key

check mark

check mark

 

Affects Version Issue Id / Issue Id

check mark

check mark

 

Affects Version Name / Version Name

check mark

check mark

 

Version ID

minus

check mark

 

Components / Project Components

Component Issue Key

check mark

minus

 

Component Issue Id

check mark

minus

 

Component Description / Description

check mark

check mark

 

Component Lead / Lead Name

check mark

check mark

 

Component Lead Id / Lead Id

check mark

check mark

 

Component Name

check mark

check mark

 

Component ID

minus

check mark

 

Issue Count

minus

check mark

 

Project ID

minus

check mark

 

Project Key

minus

check mark

 

Issue Components

Component ID

minus

check mark

 

Component Name

minus

check mark

 

Issue ID

minus

check mark

 

Issue Key

minus

check mark

 

Jira Groups / Group Members

Group Name

check mark

check mark

 

Member User Key

check mark

check mark

 

Member Username

check mark

check mark

 

Users

User Key/ User ID

check mark

check mark

 

User Name

check mark

check mark

 

User Is Active / Is Active?

check mark

check mark

 

User TimeZone / Timezone

check mark

check mark

 

User Email / Email

check mark

check mark

 

User Username

check mark

minus

 

User Last Login

check mark

minus

 

Created At

check mark

minus

 

Locale

minus

check mark

 

Account Type

minus

check mark

 

User Project Roles / Project Role Members

User ID

check mark

check mark

 

User Name

check mark

check mark

 

User Email

check mark

check mark

On Cloud can be retrieved from the 'Users' section

User Group Name / Group Name

check mark

check mark

 

User Is Active

check mark

minus

 

Directory ID

check mark

minus

 

Directory Name

check mark

minus

 

Project ID

check mark

check mark

 

Project Name

check mark

check mark

 

Project Role ID

check mark

check mark

 

Project Role Name

check mark

check mark

 

Project Roles

Project Role ID

minus

check mark

 

Project Role Name

minus

check mark

 

Role Description

minus

check mark

 

Scope Project ID

minus

check mark

 

Group Members

Group Name

minus

check mark

 

User ID

minus

check mark

 

User Name

minus

check mark

 

Jira Software

Functionality

Server

Cloud

Notes and How-To

Sprints

Issue Sprints Count

check mark

minus

 

Sprint Numeric ID

check mark

minus

 

Sprint Id

check mark

check mark

 

Sprint Complete Date / Complete Date

check mark

check mark

 

Sprint End Date / End Date

check mark

check mark

 

Sprint Start Date / Start Date

check mark

check mark

 

Sprint Activated Date

check mark

minus

 

Sprint Goal / Goal

check mark

check mark

 

Sprint Name

check mark

check mark

 

Sprint State / State

check mark

check mark

 

Story Points Committed

check mark

check mark

On Cloud can be found in the 'Velocity Charts' section

Story Points Completed / Completed

check mark

check mark

Story Points Remaining

check mark

check mark

Can be calculated as 'Commited - Completed'

Origin Board ID

minus

check mark

 

Applied filters: Projects; Boards; Sprints; Sprints States (future, active, closed)

check mark

check mark

All unique Boards chosen by Boards and Projects filters are combined into one list filtered by Boards Types.

All unique Sprints loaded by unique Boards list and Sprints Filter Values filtered by Sprints States filter.

Epics

Epic Color

check mark

check mark

Can be found (if were added in Jira) in 'Issue Custom Fields' section in Jira a Work Management

Epic Link

check mark

check mark

Epic Name

check mark

check mark

Epic Status

check mark

check mark

Sprint Issues / Issue Sprints

Issue Id

check mark

check mark

 

Issue Key

check mark

check mark

 

Sprint Id

check mark

check mark

 

Sprint Name

check mark

check mark

 

Sprint State

check mark

check mark

On Cloud can be found in the 'Sprints' section

Story points

check mark

minus

 

Applied filters: Projects; Boards; Sprints; Sprints States (future, active, closed);

Filter by JQL

check mark

check mark

All unique Boards chosen by Boards and Projects filters are combined into one list and filtered by Boards Types.

All unique Sprints loaded by unique Boards list and Sprints Filter Values filtered by Sprints States filter.

All Issues filtered by sprints and JQL Filter value loaded and exported.

Boards

Board Name

check mark

check mark

 

Board Type / Type

check mark

check mark

 

Sprints Count

check mark

minus

 

Issues Count

check mark

minus

 

Board ID

minus

check mark

 

Location ID

minus

check mark

 

Location Name

minus

check mark

 

Estimation Type

minus

check mark

 

Estimation Field Name

minus

check mark

 

Applied filters: Projects; Boards; Boards Types (scrum, kanban, simple)

check mark

check mark

All unique Boards chosen by Boards and Projects filters are combined into one list and filtered by Boards Types.

Board Charts / Velocity Charts

Board Id

check mark

check mark

 

Board name

check mark

check mark

 

Sprint Id

check mark

check mark

 

Sprint Name

check mark

check mark

 

Sprint State

check mark

check mark

On Cloud can be found in the 'Sprints' section

Sprint Goal

check mark

check mark

Sprint Activated Date

check mark

minus

 

Sprint Start Date

check mark

check mark

On Cloud can be found in the 'Sprints' section

Sprint End Date

check mark

check mark

Sprint Complete Date

check mark

check mark

Velocity Chart Commitment / Commitment

check mark

check mark

 

Velocity Chart Completed /

check mark

check mark

 

Sprint Report Completed

check mark

check mark

 

Sprint Report Completed (Current)

check mark

minus

 

Sprint Report Not Completed

check mark

minus

 

Sprint Report Not Completed (Current)

check mark

minus

 

Sprint Report Completed Outside Sprint

check mark

minus

 

Sprint Report Completed Outside Sprint (Current)

check mark

minus

 

Sprint Report Removed From Sprint

check mark

minus

 

Sprint Report Removed From Sprint (Current)

check mark

minus

 

Sprint Report Completed Issues Count

check mark

minus

 

Sprint Report Not Completed Issues Count

check mark

minus

 

Sprint Report Completed Issues Count Outside Sprint

check mark

minus

 

Sprint Report Removed Issues Count From S

check mark

minus

 

Total Considered Issues

minus

check mark

 

Applied filters:

check mark

check mark

All unique Boards chosen by Boards and Projects filters are combined into one list filtered by Boards Types.

All Sprints loaded by a unique Boards list filtered by Sprints filter.

All unique Velocity Charts items loaded and exported.

Sprint Reports

Board ID

minus

check mark

 

Board Name

minus

check mark

 

Sprint ID

minus

check mark

 

Sprint Name

minus

check mark

 

Completed Initial Estimate Sum

minus

check mark

 

Completed Estimate Sum

minus

check mark

 

Total Completed Issues

minus

check mark

 

Incompleted Initial Estimate Sum

minus

check mark

 

Incompleted Estimate Sum

minus

check mark

 

Total Incompleted Issues

minus

check mark

 

Completed Outside Sprint Initial Estimate Sum

minus

check mark

 

Completed Outside Sprint Estimate Sum

minus

check mark

 

Total Completed Outside Sprint Issues

minus

check mark

 

Removed From Sprint Initial Estimate Sum

minus

check mark

 

Removed From Sprint Estimate Sum

minus

check mark

 

Total Removed Issues From Sprint

minus

check mark

 

Total Added Issues During Sprint

minus

check mark

 

Applied filters: Projects; Boards; Sprints; Sprints States (active, closed)

minus

check mark

All unique Boards chosen by Boards and Projects filters are combined into one list filtered by Boards Types.

All Sprints loaded by a unique Boards list filtered by Sprints and Sprints States filter.

All unique Sprints Reports items loaded and exported by unique Boards.

Sprint Report Issues

Board ID

minus

check mark

 

Board Name

minus

check mark

 

Sprint ID

minus

check mark

 

Sprint Name

minus

check mark

 

Issue ID

minus

check mark

 

Issue Key

minus

check mark

 

Initial Estimate

minus

check mark

 

Current Estimate

minus

check mark

 

Sprint Report Issue Status

minus

check mark

 

Is Added During Sprint?

minus

check mark

 

Applied filters: Projects; Boards; Sprints; Sprints States (active, closed); Issues Types; Issues Statuses

minus

check mark

All unique Boards chosen by Boards and Projects filters are combined into one list filtered by Boards Types.

All Sprints loaded by a unique Boards list filtered by Sprints and Sprints States filter.

All unique Sprint Report Issues loaded and exported by unique Boards.BOARD_ID and Sprints.SPRINT_ID combination filtered by Issues Types and Issues Statuses Filters Values.

Sprint Report Charts

Board ID

check mark

🛠

 

Board Name

check mark

🛠

 

Sprint ID

check mark

🛠

 

Sprint Name

check mark

🛠

 

Sprint State

check mark

🛠

 

Sprint Goal

check mark

🛠

 

Sprint Activated Date

check mark

🛠

 

Sprint Start Date

check mark

🛠

 

Sprint End Date

check mark

🛠

 

Sprint Complete Date

check mark

🛠

 

Issue Key

check mark

🛠

 

Issue Report Status

check mark

🛠

 

Issue Summary

check mark

🛠

 

Issue Type

check mark

🛠

 

Issue Priority

check mark

🛠

 

Issue Status

check mark

🛠

 

Issue Estimation Value

check mark

🛠

 

Issue Current Estimation Value

check mark

🛠

 

Issue Added After Start

check mark

🛠

 

Board Issues

Board ID

check mark

check mark

 

Board Name

check mark

check mark

 

Issue ID

check mark

check mark

 

Issue Key

check mark

check mark

 

Applied filters: Projects; Boards; Boards Types (scrum, kanban, simple)

Filter by JQL

minus

check mark

All unique Boards chosen by Boards and Projects filters are combined into one list and filtered by Boards Types.

All Issues filtered by Boards and JQL Filter value loaded and exported.

Board Sprints

Board ID

minus

check mark

 

Board Name

minus

check mark

 

Sprint ID

minus

check mark

 

Sprint Name

minus

check mark

 

Applied filters: Projects; Boards; Sprints; Sprints States (future, active, closed)

minus

check mark

All unique Boards chosen by Boards and Projects filters are combined into one list filtered by Boards Types.

All Sprints loaded by a unique Boards list filtered by Sprints and Sprints States filter.

Jira Service Management

Functionality

Server

Cloud

Notes and How-To

Service Desk / Service Management Custom Fields + Service Desk

Approvals

check mark

check mark

 

Customer Request Type/Request Type

check mark

check mark

 

Organizations

check mark

check mark

 

Request Participants

check mark

check mark

 

Satisfaction

check mark

check mark

 

Satisfaction date

check mark

check mark

 

Time to first response

check mark

check mark

 

Time to first response ms

check mark

check mark

 

Time to first response Actual

check mark

check mark

 

Time to first response Actual ms

check mark

check mark

 

Time to first response Target

check mark

check mark

 

Time to first response Target ms

check mark

check mark

 

Time to first response Breached

check mark

check mark

 

Time to resolution

check mark

check mark

 

Time to resolution ms

check mark

check mark

 

Time to resolution Actual

check mark

check mark

 

Time to resolution Actual ms

check mark

check mark

 

Time to resolution Target

check mark

check mark

 

Time to resolution Target ms

check mark

check mark

 

Time to resolution Breached

check mark

check mark

 

Time to close after resolution

minus

check mark

 

Time to review normal change

minus

check mark

 

Satisfaction Comment

minus

check mark

 

Service Desk ID

minus

check mark

 

Project Name

minus

check mark

 

Project ID

minus

check mark

 

Project Key

minus

check mark

 

Organization Members

Organization ID

minus

check mark

 

Organization name

minus

check mark

 

User ID

minus

check mark

 

User Name

minus

check mark

 

Is Active?

minus

check mark

 

Timezone

minus

check mark

 

Email

minus

check mark

 

Customers

Service Desk ID

minus

check mark

 

Project Key

minus

check mark

 

Customer ID

minus

check mark

 

Customer Name

minus

check mark

 

Is Active?

minus

check mark

 

Timezone

minus

check mark

 

Customer Email

minus

check mark

 

Queues

Service Desk ID

minus

check mark

 

Project Key

minus

check mark

 

Queues ID

minus

check mark

 

Queues name

minus

check mark

 

Issue Count

minus

check mark

 

Issues in Queue

Queues ID

minus

check mark

 

Queues name

minus

check mark

 

Issue ID

minus

check mark

 

Issue Key

minus

check mark