give me a query to fetch the stories for a person where in sub-tasks, bugs assigned under stories

Question

give me a query to fetch the stories for a person where in only sub-tasks, bugs assigned to that person under stories

im trying fetch the story points for a story by taking the stories list for a person where he is assigned to only subtasks not the story 
so if i fetch the all the stories i callibrate the story points

Charlotte Santos -Appfire- · Answer

Hi @Manoj.GG

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, natively, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to get stories whose sub-tasks are assigned to a specific user:

issue in parentsOfSubtasksInQuery("assignee=janedoe”) AND type=Story

Please contact our support if you have any other questions about this query, or the app in general.

We’ll be happy to help you! 😉

Manoj Kumar Gangwar · Answer

Hi @Manoj.GG Welcome to the Community!

If you do not have the scriptrunner plugin then you can first fetch sub-tasks or bugs assigned to a user and then manually find their parent stories:

assignee = johndoe AND issuetype in (Sub-task, Bug)

To narrow down to only those where the parent is a Story:

assignee = johndoe AND issuetype in (Sub-task, Bug) AND parent in (issuekey1, issuekey2, ...)

If you have the plugin then you can try below JQL:

issueFunction in parentsOf("assignee = johndoe AND issuetype in (Sub-task, Bug)") 
AND assignee != johndoe AND issuetype = Story