Get product advice from experts

Ask a question →

Join a community group

Find a group →

Advance your career with learning paths

Take a free class →

Earn badges and rewards

Connect and share ideas at events

See the calendar →

Community
Products
Jira
Questions
JQL for finding issues recently moved from Unassigned to Assigned ?

JQL for finding issues recently moved from Unassigned to Assigned ?

I'm interesting in searching for all issues in a project that were Unassigned and are now Assigned, in say that last 24 hours. So 24 hours ago they were Unassigned and now they are not.

Thanks for all help in advance.

Karla

2 answers

2 votes

The following JQL would return issues who's assignees have been changed for unassigned to someone else since the start of the day

assignee changed AFTER startOfDay() and assignee is not EMPTY

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

Comment

You're 3/4 of the way there!

Anyway to know if they were UNASSIGNED before they were assigned? This shows that the Assignee has changed, but not that the issues were Unassigned prior to that.

This is a lot more than I had, so thank you for that!!

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

Comment

Like

Maybe this:

assignee changed FROM empty AFTER startOfDay() and assignee is not empty

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

Comment

Like

That returns nothing at all. Looks good tho. :)

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

Comment

Like

Reply

1 vote

Adding on @Tayyab Bashir's answer to solve for the missing piece. :)

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

Comment

Reply

Suggest an answer

Log in or Sign up to answer

Was this helpful?

Thanks!

TAGS

Community showcase