what JQL expression do I use to search for the newest issues assignee to me?

I need to show in a dashboard the newest issues that was assignee to me. I made a filter, but it return in the frist and secund places issues that are old than the third and Fourth place. here is the jql that I made:

" assignee = USER.JIRA AND status not in (STATUSes THAT DON'T matter) ORDER BY updated DESC "



2 answers

Change the "UPDATED" to "CREATED"

1 vote
Ignacio Pulgar Community Champion Aug 13, 2015

Besides the change proposed by Gabrielle, I'd suggest changing 

status not in (STATUSes THAT DON'T matter)


statusCategory != Done

That change will probably match your needs provided the statuses you are using were well categorised- and make your JQL query more readable and easier to maintain.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Apr 17, 2018 in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

809 views 2 19
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you