Need JQL to search my following Queries

Question

How can i get following results with JQL, please comments JQL

1.       Epics which are not started yet ( in Backlog state) but its related stories are in active state (Other than backlog).

2.       Active Epics (state other than blocked, backlog and done), whose children are in the done state.

3.       Active stories (state other than blocked, backlog and done), which have more than one sprints.

4.       Active stories (state other than blocked, backlog and done), which have more than TWO sprints.

5.       Stories which are in Done state but have no subtask.

6.       Active Bugs(state other than blocked, backlog and done), which have more than one sprints.

7.       Bugs which directly went from backlog state to done state

Adeel Nazir · Answer

Hi @Ignacio Pulgar ,

I got Solution for #1: issuetype = epic and status = Backlog and not (issueFunction in linkedIssuesOf("status != backlog", "has Epic"))

Similarly i want others can you please help me in this regard

Ignacio Pulgar · Answer

Hi Adeel,

Two important questions here:

* Server or Cloud?
* Does the instance count with ScriptRunner?

Without the help of a third party app, like SR, you may get the info you need by exporting issues to CSV and treat the resulting spreadsheet as per your needs.

The query #7 is the only one that can be obtained through a native JQL:

type = Bug AND status CHANGED FROM Backlog TO Done AND status = Done