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

[Thomas Cucolo]

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 

[Jack Brickey · Accepted solution]

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.

[Thomas Cucolo]

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 Brickey]

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. 

[Nic Brough -Adaptavist-]

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

[Bill Sheboy]

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.