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
4,294,747
Community Members
 
Community Events
165
Community Groups

Help creating complex filter

Hello guys!

I am working on a new automation but having trouble getting my filter to pull back the details I need. I am looking to create a filter to show all issues that have been in the status "With User" for at least 3 days.

 

This is the closest I could get, but this is not really what I need because the updatedDate on all these issues are showing today:

 

project = myColorado AND status = "With User" And updatedDate <= now() order by created DESC

 

Any idea how I can do a filter based on how long an Issue has been in a certain status? Or maybe even a filter based on the updated date + 3?

 

My automation is going to auto transition issues that have been in the With User Status for at least 3 days to resolved.

 

Any help would be greatly appreciated! 

1 answer

1 accepted

3 votes
Answer accepted
Mark Segall Community Leader May 20, 2022

Hi @JayJuan Jones 

You want something like this:

project = myColorado AND status changed to "With User" before -3d AND status was not "ANOTHERSTATUS" after -3d AND status = "With User"

This will look for anything that has legitimately stayed in "With User" status for at least 3 days straight.  Meaning... It never transitioned to another status and back.  If this interests you, just replace "ANOTHERSTATUS" with whatever status With User may have transitioned to. If not, simply remove the status was not clause

that did the trick for me! thanks so much @Mark Segall 

Like Mark Segall likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Posted in Jira Service Management

Jira Service Management Documentation Opportunities

Hello everyone, Hope everyone is safe! A few months ago we posted an article sharing all the new articles and documentation that we, the AMER Jira Service Management team created. As mentioned ...

275 views 0 6
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