A connector URL has section headers which are helpful in determining and categorizing the fields available in Jira in respective sections.
How to create the connector URL?
Log in to Jira and navigate to the global navigation Menu (on the top) → AIO Tableau
Please note that access to the app is controlled by the Access Permissions option, which is accessible only by the Jira administrator. Please note: If the group (they belong to) is not selected, users will not see the AIO Tableau menu item. In this case, the Jira administrator can perform the below steps:Copy the connector and import it into Tableau Desktop or Server through Web Data Connector.
Enter the JQL (if required) and click continue.
Select the appropriate fields available under the section headers to import the respective field's data.
For more detailed information, please refer to the table below:
Section headers in connector | Details | |
---|---|---|
1 | Common | All the basic fields in Jira exists here. Issue key is selected by default in this section. |
2 | Comments | Any information related to comments in an issue can be pulled through the fields from this section. For example: Comment Author, Comment Id, Comment Created, Comment Updated, etc. |
3 | Custom | Any custom fields that are created in Jira exists here. |
4 | Dates | All the system/custom date fields that are present in Jira can be found here. |
5 | Epic | All the epic related fields can be found here. For example: Epic Link, Epic Name, Epic Status etc. |
6 | Fix Version | Any information related to Fix version of an issue can be pulled through the fields from this section. For example: Fix Version Name, Fix Version Id, Fix Version Release Date etc. |
7 | Groups (Requires Jira administrative access) | Any information related to a user group can be found here. Note: User should have Jira administrator access to be able to see this section. |
8 | History | Any information related to the history of an issue can be found here. For example: Time in Old Value, Time in New Value, New Value Start Date, History Author etc. |
9 | Issue Effort | Any information related to time spent and estimates can be found here. For example: Original Estimate, Time spent etc. |
10 | Linked Issues | Any information related to issues linked to each other can be found here For example: Linked Issues: Key, Linked Issues: Direction. |
11 | Other | All the other information like Security, Components, Votes , Watchers etc can be found here. |
12 | Parent Issue | Any information related to the parent issue of the subtask can be found here. For example: Parent Issue Key, Parent Issue Status etc. |
13 | Portfolio | If the app Advanced Roadmaps for Jira Software (formerly Portfolio) is installed, then the respective fields can be found here. For example: Parent Link |
14 | Project | Any information related to the project can be found here. For example: Project Key, Project Lead, Project Type etc. |
15 | Project Members | Any information related to the users and roles i.e., members of the project can be found here. For example: Project Role, Project Member etc. |
16 | Remote Links (Add only if needed; this will slow down the extract refresh) | Any information related to Application links can be found here. For example: Any incoming and outgoing links configured. |
17 | Service Desk | Any information related to Jira Service desk can be found here. For example: Time to resolution, Resolution etc. |
18 | Service Desk: Request Types | Any information specific to Jira Service desk request types can be found here. |
19 | Service Desk: SLA Cycles | Any information specific to Jira Service desk SLA cycles can be found here. For example: SLA Cycle Status, SLA Name etc. |
20 | Sprint | Any information related to basic sprint details can be found here. For example: Sprint Name, Sprint Goal etc. |
21 | Sprint Metrics (Add only if needed; this will slow down the extract refresh) | Any detailed information on sprint data can be found here. For example: Sprint Committed Issue Count, Sprint Committed SP etc. |
22 | Story Points | Any information on story points can be found here. For example: Story Points, Story Points Completed, Story Points Remaining. |
23 | Time Tracking (Worklogs) | Any information related to time logged on an issue can be found here. For example: Time Entry User, Worklog ID etc. |
24 | Time in Status | Any information related to an issue being in a particular status for certain time can be found here. For example: History Status, Status sequence, Time in status etc. |
25 | Time with Assignee | Any information related to an issue being assigned to a paricular user for certain time can be found here. For example: History Assignee, Assignee sequence, Time with assignee etc. |
26 | Users | Any information of a user within the Jira instance can be found here. For example: Creator: Name, Reporter: Name, Current Assignee: Name etc. |