Jira

Jira is project management software that can be used for bug tracking, where various teams can collaborate on any project.

Sync Jira data to Sourcetable

Build reports once. Connect to Jira and start modeling from live data.

Popular Use Cases

Jira connector Sourcetable connector
Create reports using Jira data
Jira + Sourcetable
Jira connector Sourcetable connector
Create a burn chart of all active Jira tickets
Jira + Sourcetable
Jira connector Asana connector
Get a combined list of Jira tickets and Asana tasks
Jira + Asana
Jira connector Sourcetable connector
Search all active Jira tickets, by type
Jira + Sourcetable
Jira connector Sourcetable connector
Automate Jira reporting using Sourcetable
Jira + Sourcetable
Here's a sample of the Jira data that will be available in your Sourcetable spreadsheets:
BOARD

A board is place where you can see all the issues which are created

COMMENT

You can add a comment on any issue to give additional information

COMPONENT

A component has project information, a name and a description

EPIC

You can create an EPIC in case you wish to group some issues under a common task

FIELD

A field has a name, it can be of array type or a custom field type

FIELD_OPTION

It has name and a parent id which holds id of field option

ISSUE

An issue is a task which needs to be worked upon and has description associated with it which tells what needs to be accomplished

ISSUE_BOARD

It has associations of issue id and board id

ISSUE_FIELD_HISTORY

It has associations of issue id field id and has fields like time and value

ISSUE_LINK

It has associations of issue id, related issue id and relationship field

ISSUE_MULTISELECT_HISTORY

Contains field id, issue id, time and value

ISSUE_TYPE

It tells the type of the issue whether it is a bug, an improvement or something else

ORGANIZATION

The company that has JIRA account subscription

PERMISSION

A permission is an access right

PERMISSION_HOLDER

Assocaition table that stores permisssion information, permission scheme, user, project role, user custom field

PERMISSION_SCHEME

Contains id, name and description fields

PRIORITY

It defines the priority of the issues

PROJECT

It has fields like project category, permission schedule, user, key, name, and description

PROJECT_BOARD

It has association of project id and board id

PROJECT_CATEGORY

It has name and description

PROJECT_ROLE

It has name and description

PROJECT_ROLE_ACTOR

It has project id, project role id, user group and user

RESOLUTION

Contains name and description

SLA

Contains the Service Level Agreement information

SPRINT

A sprint is a duration in which developers complete some issues, normally used in the Agile methodolgy

STATUS

Contains status category id, name and description

STATUS_CATEGORY

Contains name and id

USER

The user which is using the JIRA software and has fields like name, email, locale, username and timezone

USER_GROUP

Contains associations of user and has a group name

VERSION

Contains project id, arcived, description, name, overdue, released, release date and start date

WORKLOG

Contains the time information which was spent on an issue