nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need help in JQL

gaurav kapoor_x03a5m

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

Accepted answers

All comments

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_x03a5m

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

gaurav kapoor_x03a5m

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

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:

References:

Official documentation

Hope this helps you to create awesome queries

Kind regards

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server