JQL for Issues going from Unassigned to Assigned

[Chris Green]

Trying to create a filter where I can view tickets that were in our unassigned queue, but got assigned / picked up since the start of day. I looked at both of the Community articles below, but neither provides me with what I'm looking for. 

Does anyone have any thoughts? 

This is the closest I've gotten, but it doesn't return tickets that have been created since start of day:

AND assignee changed after startOfDay() AND assignee was EMPTY AND assignee is not EMPTY ORDER BY created ASC

• https://community.atlassian.com/t5/Jira-questions/JQL-For-Recently-Assigned-Issues/qaq-p/1012126
• https://community.atlassian.com/t5/Jira-questions/JQL-for-finding-issues-recently-moved-from-Unassigned-to/qaq-p/640226

[Seifallah Bellassoued]

Dear @Chris Green

You can try the following:

( created >= startOfDay() or assignee changed after startOfDay()) AND assignee was EMPTY AND assignee is not EMPTY

Best Regards,

[Chris Green]

That doesn't seem to work either for some reason. It's still only pulling tickets that were created up through 19/Feb/25 and not including 20/Feb/25 (today) which I'd expect it to. 

[Seifallah Bellassoued]

I belive you are adding some other parameters to your query. Can you share the full query you are using.

[Chris Green]

project = SCSD AND issuetype = ticket AND department in ("Client Support Services", "Client Support Services (Environments)", "Client Support Services (Custom Reports)", "Client Support Services (Implementations)") AND ( created >= startOfDay() or assignee changed after startOfDay()) AND assignee was EMPTY AND assignee is not EMPTY

[Seifallah Bellassoued]

Dear @Chris Green

The query should works fine. Maybe, you don't have any ticket that meet the criterea.

[Chris Green]

not sure why but the 'assignee was EMPTY' criteria doesn't seem to work for me. I removed that and just used the following, however, it's only considering a change in assignee for created tickets after start of the day, but I think we may only have a couple outliers here (i.e. ticket is picked up/assigned) and changed to another assignee.

project = SCSD AND issuetype = ticket AND department in ("Client Support Services", "Client Support Services (Custom Reports)", "Client Support Services (Implementations)") AND created >= startOfDay() AND assignee changed after startOfDay() and assignee is not EMPTY