Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Create a filter to display me recent updated issues that are still open

Oliver August 21, 2020

Hey Guys,
i want to create a filter that shows me recent updated issues that are still open. It is for our dashboard that is displayed on a Tv in the office.

 

Can you help me?

 

Oliver

1 answer

1 accepted

1 vote
Answer accepted
Mehmet A _Bloompeak_
Atlassian Partner
August 21, 2020

Hi @Oliver ,

Below list issues updated in last 1 day an status is not done. Hope it works.

status !=DONE AND updated >= -1d order by created DESC
Jack Brickey
Community Champion
August 21, 2020

One suggested change...

statuscategory !=DONE AND updated >= -1d order by created DESC

feel free to change the “1” to align with how you define recent 

Like # people like this
Oliver August 24, 2020

Thank you guys for your help.

 

But I have another question.

Can you "exclude" new issues that have been made in recent time?

 

Cheers Oliver

Jack Brickey
Community Champion
August 24, 2020

sure/maybe.... lets say you want to exclude issues create in the last 24h...

AND createddate < startofday(-1d)

Suggest an answer

Log in or Sign up to answer