Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

I need to find all features that are not in Implementing and have stories that are in progress

I am writing a filter to find all active stories in a feature that is in Funnel. 

Project = (project name) AND issuetype = Feature AND Status= Funnel and Issuetype = story and status = In Progress

Each stands on its own but together nothing is returned, I have tried:

((Project = (project name) AND issuetype = Feature) AND (Status= Funnel and Issuetype = story and status = In Progress)

Still not returning anything 

 

 

2 answers

1 accepted

0 votes
Answer accepted
Jack Community Leader Jan 14, 2021

So your first JQL is flawed as you are asking for issues that have two types and an issue can have only one type. A correct filter might be...

Project = (project name) AND issuetype = Feature AND Status= Funnel OR (Issuetype = story and status = In Progress)

with that said i'm a bit concerned with the potential relationship of Features and Story issue types. I assume Feature is an issuetype you have created or is this some advanced roadmap capability here? In my world if I create a "Feature" issuetype it would be at the same level as story.

So my company uses Features for the name of an Epic. What I am looking for is a Product Owner not placing the feature/epic in Implementing when a developer has started to work on a story in the (epic)

Jack Community Leader Jan 14, 2021

rather than chasing out of process conditions why not take an automated approach to ensure things work the way you want. Use Automation to move the Epic to In Progress as soon as the first story is moved to in progress. If that is of interest just let me know. 

0 votes

Parentheses are always your friend with multi-clause JQL, but they don't do anything when you're only using AND.

Project = (project name) AND issuetype = Feature AND Status= Funnel and Issuetype = story and status = In Progress

This will find issues where

  • Project = X
  • issue type is feature
  • issue type is story
  • status is funnel
  • status is in progress

Note that I've grouped them by field to highlight the problem (AND is commutative, it doesn't matter what order it joins clauses together)

You're asking for issues that are features and stories at the same time.  As the issue type is a singleton, that can never happen.  Same goes for status, you're asking for issues which have two status at the same time.

So, my guess is that you mean "or" in some places (and when using OR, parentheses are really helpful!)

Project = (project name) AND ( issuetype = Feature AND Status= Funnel) OR (Issuetype = story and status = In Progress) )

This will find issues where

  • Project = X
  • issue type is feature and status is funnel
  • issue type is story status is in progress

Or, is the question about when the stories within the feature which are in progress?

  • Select all the Features
  • Where the project = X
  • And the Status = Funnel
  • And there exist Stories in the Feature...
    • Where the Story Status= In Progress

 

If so, that is not possible with out-of-the-box, JQL.  It would require a scripting add-on.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

7,184 views 8 28
Join discussion

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