nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

sql to get Epic workflow status

Dhoni

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.

Accepted answers

Nic Brough -Adaptavist-

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).

All comments

Nic Brough -Adaptavist-

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.