Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How to create a filter to check for all tickets which might have been assigned to a specific status?

I want to create a filter for any tickets which might have been set to a specific status and changed later during the project's lifetime.

Any idea what kind of search filter function would help?



1 answer

1 accepted

0 votes
Answer accepted
John Funk Community Leader Nov 23, 2021

Hi @Sree Ram Nair  - Welcome to the Atlassian Community!

You can use a JQL like:

project = JIRA and status was in ("In Progress") DURING (2021-10-01, 2021-10-31)

The DURING part is not needed but will narrow down by date when the issue was in that status. 

Thank you John! It worked like a charm.

Apologies that I couldn't revert earlier.

Thank you again & have a great year ahead!

Like John Funk likes this
John Funk Community Leader Dec 23, 2021

Thank you, Sree - you, too!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Service Management

Improving the Create Issue Experience in Jira Service Management Cloud

Hello everyone!  We are very excited to announce some much needed changes to the issue create experience in JSM (the blue "create" button) at the top of the screen.  We have just starte...

205 views 7 7
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