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

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

Accepted answers

Jack Brickey

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.

All comments

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

Jack Brickey

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)

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)

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.

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.

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud