Need help in JQL

[gaurav kapoor]

Hi,

I have the details of the tasks based on 'assigned' attribute, and this details can be pulled easily using JQL.

Now, within a query is it possible to pull the backlogs of these tasks, by making use of subquery, function etc?

Thanks and Regards

Gaurav

[Jack Nolddor _Sweet Bananas_]

Hi again,

Sadly you cannot filter parents issues based on child's criteria using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

Pull the backlogs based on a previous child tasks criteria, i.e.:

type = "Backlog Item" AND issue IN parentsOf(' project = XXX AND issuetype = Task AND assignee in (aa, bb, cc) AND updated >= startOfYear() ')

Note that this is just an example, you must tune above query to fit your needs

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation

Hope this helps you to create awesome queries <3

Kind regards

[gaurav kapoor]

Dear Jack,

Thanks for responding.

I have attached a pic which shows 'Backlog Item' and 'Tasks' under it.

The hierarchy which we use/know is : Project -> Backlog Item -> Tasks

To reiterate my question, I have the tasks assigned to few known people and this data can be pulled using the below JQL:

project = XXX AND issuetype = Task AND assignee in ( xx, yy, zz) AND updated >= startOfYear()

However, if I wish to pull the Backlog Items of these resultant sub tasks, then is that possible? If yes, then can you suggest me how to do it?

Thanks and Regards

Gaurav

[Jack Nolddor _Sweet Bananas_]

Hello and Welcome,

Please could you further explain us what do you mean by "backlogs" ? Could you add some picture to better describe your requirement?

Regard

[gaurav kapoor]

[gaurav kapoor]

Dear Jack,

Thanks for responding.

PFA the picture which shows Backlog Item and Sub Tasks. The hierarchy which we know/use is : Projects -> Backlog Items -> tasks.

Now, I can fetch all tasks using the below JQL:

project = XXX AND issuetype = Task AND assignee in (aa, bb, cc) AND updated >= startOfYear()

However, if I have to fetch the corresponding backlog items for these resultant tasks, then is there any way to do so? 

Thanks and Regards

Gaurav