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; } } }

How to use nested subquery to search issues

Avinash Londhe

Board1: Level1_Query: Display specific set of initiatives (not all)

Project = "xyz" AND Type = "Initiative" AND Labels in (A01, B01,C01,D01)

Board 2: Level2_Query: Display Epics for above set of initiatives linked by "Parent Link"

Project = "xyz" AND Type = "Epic" AND IssueKey In (Level1_Query)

Complete Query: Project = "xyz" AND Type = "Epic" AND IssueKey In ('Project = "xyz" AND Type = "Initiative" AND Labels in (A01, B01,C01,D01)')

Board 3: Level3_Query: Display Epic and their next level children;stories/tasks (Not the Sub-Tasks)

Project = "xyz" AND Type NOT IN ("Initiative") AND IssueOfEpics (Level2_Query)

Board 4: Level4_Query: Display Stories/Tasks from level 3 with their sub tasks

Project = "xyz" AND Type NOT IN ("Initiative","Epic") AND IssueOfEpics (Level3_Query)

----

Basically I want to implement nested queries in filter criteria. Any help would be appreciated.

Accepted answers

Alexey Matveev

Hello,

I am not sure from which plugin you have the IssueOfEpics function, but you could use filters as nested queries.

You could create a filter and then use it in JQL query like this:

filter = <your filter id>

All comments

Alexey Matveev

Hello,

I am not sure from which plugin you have the IssueOfEpics function, but you could use filters as nested queries.

You could create a filter and then use it in JQL query like this:

filter = <your filter id>

Avinash Londhe

ok let me give it a try

Avinash Londhe

IssueOf Epics is just some text. Was trying to explain what I am trying to achieve.

Avinash Londhe

Can you give me example for below:

This is what I am trying to achieve…

Board1_Initiatives_Query: Display specific set of initiatives (not all)

e.g. Project = "xyz" AND Type = "Initiative" AND Labels in (A01, B01,C01,D01) ‘---OK no Issues

Board2_Epics_Query: Display Epics (only) for above set of initiatives linked by "Parent Link"

e.g. Project = "xyz" AND Type = "Epic" AND status In (“Open”,”In-Dev”,”In-QA”) AND issue in issuesParents (Board1_Initiatives_Query)

Board3_Ticket_Query: Display Epic and their next level; stories/tasks/defects (Not the Sub-Tasks) for above set of epics

e.g. Project = "xyz" AND Type NOT IN ("Initiative",”Sub-Tasks”) AND issueFunction in issuesInEpics(Board 2_Epics_Query)

And so on…

Bari Nuhiji_f6ar9o

Hi,

I have been successful with . Jira query to get all the stories for a given set of 'Features' associated with a parent Epic.

Note that we have not created a parent 'Initiative', but simply associated a parent Epic to Child Epics 'Is Implemented By' relationship'.

ie.

DES-001 (parent epic)
DES-002 (child epic) - "Feature" Is Implemented By
DES-003 (story) - associated with DES-002

The query to give me the list of all stories under DES-001 is:

issueLink in (linkedIssues(DES-001)) AND Type = Story ORDER BY "Epic Link"

The ORDER BY provides a visual grouping of stories per Epic (level 2).

The output would be DES-003 only. But if you had 50 level 2 epics, then it would return all the stories associated with Level 2 'Features' (of type Epic). Simply labelling the level 2 Epics as 'Features' would provide a way of tracking them accordingly.

Cheers.

Murali G_t03wvh

While running the following query i.e issueFunction not in issuesInEpics("Clarity Project= P000000290 ABC XYZ 2.0")

getting the below error

Error in the JQL Query: Expecting operator but got 'Project'. The valid operators are '=', '!=', '<', '>', '<=', '>=', '~', '!~', 'IN', 'NOT IN', 'IS' and 'IS NOT'. (line 1, character 9)

some one can help me like how to override the spaces in subqueires?

Helga Tryggvadóttir_dbn5m7

I know it's been a while since Avinash posted this question, but I was searching for a similar solution recently and I came across this available function in Jira cloud:

issuekey in portfolioChildIssuesOf(Initiative-1)

This gives all Epics, Tasks etc for Initiative "Initiative-1".

Welcome!

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

Quick Links

Find more posts tagged with

jira

atl-gruland