JQL for finding issues recently moved from Unassigned to Assigned ?

Karla Russell September 14, 2017

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

 

1 answer

1 vote
Tayyab Bashir
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 14, 2017

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
Karla Russell September 14, 2017

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!!

Gaston Valente
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 14, 2017

Maybe this:

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

Karla Russell September 14, 2017

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events