It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Jira Server and Process Mining Edited

Hello,

We would like to study the stock of issues and the workflow they're rattached to. We would like to study the speed of the issues to run through the workflow from the beginning to the end.

We would like to make a data extraction from the database.

We need to find the tables which give us the workflow steps with the timestamps for each issue. We would like clear labels for each technical ID.

We identified the table jiraissue as the table referencing all the issues created with Jira Software. We can manage with the customfields and the users.

Can you give us the different tables involved or directly the SQL requestfor having the workflow steps with the timestamps for each issue, and clear labels for each technical ID, please ?

Thanks in advance.

1 answer

0 votes

Ugh, no, that's a horrible thing to do.

You can get much clearer, easily read/parsed, data from a single REST call to fetch the whole issue, including its history, rather than having to build complex messy (and often completely wrong) SQL.

Hello,

Unfortunately, the process minig team is working on a separate database with no Jira Server application deployed. They do need to extract data directly from the database to inject into their specific tool.

I found a solution in the developper forum.

Thank you.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

303 views 1 3
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you