JIRA Nested Query

[Sandeep Singh]

(project = MSDI AND status in (Closed) AND (issuetype as "Story" in (issuetype in ("Defect") And project = MSDI AND status in (Closed) ) ) )

Need to retrieve no. of JIRA Stories and the no. of defects linked to them

[Sandeep Singh]

Hi Benn,

Thanks for your response. 

I tries using the basic an Advanced search

Here is the problem statement:

Need to pull the "list of JIRA Stories and the respective Defect IDs" linked to them in a project using JIRA Query.

For example - If there are 5 stories and 4 defects linked to each story, then i shud expect 20 such records using JIRA Query.

Please suggest.

Regards,

Sandeep

[Benn0]

I see, that's actually tricker that I thought. I haven't been able to work out how to do it.

[Benn0]

Hi Sandeep, have you tried constructing the query using basic search. In Jira Cloud it looks like this question can be answered just using the basic search.

you could try something like

project = MSDI AND issuetype in (Story, Sub-task) AND status = Closed

Also, if you type using the advanced/JQL search, it will prompt you with options. I find it best to start with the basic search, then if you can't get your answers, switch the advanced search. Jira will show you the JQL of the basic search and then you can extend the basic search.