JQL assigne issues

Question

Hey, guys. I need to get all issues assigned to a person at the beginning of the sprint. I'm using this query:

resolutiondate >= '2023-01-01 00:00' AND resolutiondate <= '2023-03-31 23:59' AND (assignee in (currentUser()) OR "Additional Owners" in (currentUser()))

When there is movement for validation of a QA, the issue ends up being assgned to someone else and I lose the initial record. Is there a way to pull the issues assigned to a certain person at the beginning of the sprint without considering this movemet for a possible QA?

Yuri Guimarães Gadelha · Answer

Hello, @Carlos Garcia Navarro

Thank you very much. I just tried using:

sprint = 'abcdefgh' AND assignee was "abc@def.com"

But pulled other assigned. Then I refined it further using:

sprint = 'abcdefgh' AND assignee = "abc@def.com" AND assignee was "abc@def.com"

However, it pulled the uncompleted issues. I'm still looking for how to fix it.

Carlos Garcia Navarro · Answer

Hi @Yuri Guimarães Gadelha ,

Welcome to the Community! You could use the 'was' operator as described here:  https://community.atlassian.com/t5/Jira-Software-questions/How-can-I-track-original-assignee-when-story-is-being-reassigned/qaq-p/843097

E.g.:

assignee was 'johnsmith'