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 Nested Query

(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

2 answers

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.

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.




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

Suggest an answer

Log in or Sign up to answer

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