How to configure JQL filter to display certain assignees to tasks at certain time?

[alexxkey]

Hello. I want to find an answer to question about specific JQL query.

I use some gadgets on my dashboards (statistics, sumUP) to see team members and their original estimates of tasks and logged time spent.

I need to know what tasks was assigned to team members in current sprint at start of this sprint.

If I write something like that:

project = "Project Name" AND assignee was in (user1, user2) AND Sprint in openSprints()

I'll see that team lead was assigned to almost 90% of tasks, because in some statuses (like ready for code review and code review) tasks auto assigns  to him. And the other team members in this way have only 1-5% tasks. So the solution is to display assignees at the start of sprint.

How to do that?

[Thorandor]

Not sure if that helps, but what about adding:

AND assignee was not xxxx before "YYYY/MM/DD" AND assignee was xxxx before"YYYY/NN/DD"

or:

AND assignee changed to user1 before "YYYY/MM/DD" 

(or change it to on for the start date of the sprint.

Would that give you what you need?