sql to get Epic workflow status

[Dhoni]

Hi

 I'm trying to get Category, Project, Last Updated, Last Updated By, Epic Workflow Statuses, Story Workflow Statuses from JIRA in sql.

Any idea how to get it in Sql.

[Nic Brough -Adaptavist- · Accepted solution]

Welcome to the Atlassian Community!

Don't.  You'll need many queries and they are not simple.  SQL is the worst possible way to question a Jira system for data.

You could get most of this from a simple query for "issue type = Epic" and then adding all the fields you need to the issue navigator.  (Or do it over the REST API).

[Dhoni]

May i know how to write for "epic workflow status" and "story workflow status" in JQL?

[Nic Brough -Adaptavist-]

Yep, just search for the Epic, when you look at it, you'll see the Epic Status and the Epic's story status on screen.

I think you might need to explain what you are actually trying to achieve here.

[Dhoni]

I need an excel report which has all the epic workflow status and story workflow status. So that my manager can track them when needed.

[Nic Brough -Adaptavist-]

It would be better for you to teach your manager how to do simple searches in Jira so they can get the reports for themselves (and drill down into them, and not bother with information that is likely to be obsolete before they even get the report).

But the answer is simple - run a search for the issues you want to report on, and add the fields to the issue navigator - not only is that a really simple search, you can export it to spreadsheets if you must.

[Dhoni]

Thank You!! @Nic Brough -Adaptavist- 

[Bill Sheboy]

Hi @Dhoni 

Yes, and...to what Nic suggests: you may want to take this free JQL training from Atlassian on how to form queries and answer questions with JQL.

https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql

Kind regards,
Bill

[Dhoni]

Hi @Nic Brough -Adaptavist- / @Bill Sheboy 

Can anyone of you provide me the sql to get the details.

My manager needs to see it in sql itseems.

Can anyone help?

[Nic Brough -Adaptavist-]

Please explain to your manager what we've said above - "I want to do it in a certain way" is not a reason to do something really badly.

[Dhoni]

I did, no use. Can u pls send me the sql!!

Its very important

[Bill Sheboy]

Hi @Dhoni 

This is a community forum for users of Atlassian products to help other users.  It is not a free labor pool to deliver requests.  Please consider trying to learn about JQL and to answer your own questions yourself and then ask for help when you run into challenges you cannot solve.

To restate what we have already offered:

• JQL is not a SQL; it is a tool to help list issues meeting your criteria/needs.  It has some common features like a SQL, but not all of them.  Please look here for what is available, along with some examples: https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/
• You have not stated specifically what you are trying to solve, and instead have only listed some fields without any criteria.  For example, trying to find the epics which have completed in the last week.  Without describing that no one could understand how to help.
• If you are unable to do that, please consider asking some of your peers who may have more experience with Jira and JQL to help you.

Kind regards,
Bill