Jira work log and Jira linked work item data are available in data shares

[#1]

Exciting news! We’ve released Jira work log and Jira linked work item data in data shares.

• Work log data is available in the table jira_issue_worklog. Read more about the “Jira worklog” table.

• Linked work item data is available in the table jira_issue_link. Read more about the "Jira issue link" table.

• Linked work item type data is available in the jira_issue_link_type. Read more about the "Jira issue link type" table.

You can learn more about those data points in our previous Community post when we released them for Atlassian Analytics.

How can I start using this data?

You won’t need to take any action. These new tables will automatically be added to your existing data shares.

Looking for more?

Don’t hesitate to send us feedback on which data or features you want us to add next.

You can also vote on your most wanted requests for Atlassian Analytics, data shares, and the Atlassian Data Lake.

Let us know if you have any questions!

Claire Gayrard

Product Manager, Atlassian Data Lake

[Josh]

Thank you, @Claire Gayrard ! You and the rest of the team are continually delivering high value functionality for us and many other customers. We really appreciate everyone's efforts.

[Josh]

For the jira_issue_link table, is there any chance that the issue_link_type value (i.e. friendly name) could be provided along with the ID? I don't believe there's a way for us to bring in the link type name without querying the API.

This is what we're currently seeing:

Link type IDs are certainly better than no links; having the actual link type name would be additionally helpful for our users.

[Claire Gayrard]

Hi @Josh,

Thanks for reaching out. We also released the table jira_issue_link_type (read more about the "Jira issue link type" table) that I missed adding to my original post.

You can join jira_issue_link_type and jira_issue_link on issue_link_type_id. Additionally, you need to specify the link direction with jira_issue_link.link_direction and jira_issue_link_type.inward or jira_issue_link_type.outward columns.

Cheers,
Claire

[Josh]

Thank you for the helpful information, @Claire Gayrard .

Is the jira_issue_link_type table coming to Data Share? It doesn't appear to be available for us; only jira_issue_link is shown.

If it's something that we should submit a support ticket for, I'll be happy to put one in.

[Claire Gayrard]

Hi @Josh , the table should be available in your new and existing data shares.

If you don't see it, please get in touch with support, and we will be able to help you.