Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

JQL to get Epics in Backlog state but its children are in active state not Backlog

I want to extract all Epics which are not started yet ( in Backlog state) but its children are in active state (Other than backlog).

 

i have using following JQL
issuetype = epic and status = Backlog and not (issueFunction in linkedIssuesOf("has Epic", "status!=Backlog"))

 

but it returns me strage results

all stories with backlog status and 

all epics have no child

 

anyone can correct me here what i'm doing wrong here

1 answer

0 votes

I think this should work:

issueFunction in epicsOf("status != Backlog") AND status = Backlog 

Get all epics with children having a status other than Backlog and then narrow down that list to just the epics having a status of Backlog.

Hi @Wade Tracy _Boise_ ID_ 

 

You are very close to solution,

this JQL not returns  100% results

Problem is this JQL not returns all children in backlog (some of them are in backlog and some are in Done state)

Can you please modify it please to get all children not in Backlog?

I'm not sure I understand 100%.  Let me ask a few questions:

  1. Do you want the query to only return epics? or epics and their children?
  2. Do you want epics that have ANY children in statuses other than backlog? Or do you want epics that have ALL children in statuses other than backlog?

I'm hoping you want only epics and just the epics where ALL their children and not in the backlog.  Here is the query:

issuetype = epic AND issueFunction not in epicsOf("status = Backlog") AND status = Backlog

If you are looking for something else, tweak it as needed or let me know.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

☕️ Monday coffee with Jexo: Weekly Atlassian news roundup | 21st June 2021

Hi community 👋, as every Monday we're bringing you a quick update on what happened in the Atlassian ecosystem last week. There were a few interesting events like for example the announcement of th...

59 views 0 6
Read article

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