Community
Q&A
Jira
Questions
Create a filter to display me recent updated issues that are still open

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

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

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

1 vote

Answer accepted

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

AND createddate < startofday(-1d)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

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

1 answer

1 accepted

Comments for this post are closed

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events