Querying multiple users assigned to tickets in the last three months

Question

Hey guys,

Trying to export a report out of JIRA showing the number of tickets assigned to certain approvers over the past 3 months.

I can get the multiple users using 'assignee was in' but I cant seem to get the assigned in the last three months to work.

Any suggestions would be great :)

Trudy P Claspill · Answer

Using "created" or "updated" is going to to check the date the issue was created or the date it was last updated, respectively. Those dates are not related to when a particular person was an assignee for an issue.

@Gor Greyan 's suggestion will get only the issues where the assignee was changed during the date range. It won't get issues that were assigned to the users prior to 3 months ago and remained assigned to those user without be changed to one of them in the past 3 months. Does that meet your requirement?

The following will get you the issues where the assignee value was any of the specified people in the three previous calendar months, including ones that were changed to those people before the three previous calendar months and remained assigned to one of those people for some time in the three previous calendar months.

assignee was in ( user) during(startofmonth(-3),startofmonth())

Gor Greyan · Answer

Hi @Tahliah Footman

Welcome to the Atlassian Community!

Try the following JQL, I think this should fit your request.

assignee changed TO user.name after startOfMonth(-3) BEFORE startOfMonth()

Tahliah Footman · Answer

Relative value as it’s for a report they want to see what has been assigned to certain people in the last three months.

I have tried created >= startofmonth(-3) as well as updated with no luck