Querying multiple users assigned to tickets in the last three months

[Tahliah Footman]

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 Claspill]

Hello @Tahliah Footman 

Welcome to the Atlassian community.

Please share with us the JQL you are trying to use.

Review the WAS IN documentation:

https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#WAS-IN

I believe you are going to need to use the DURING predicate.

Are you trying to make "last 3 months" be a relative value, or are you using explicit dates for the range?

[Tahliah Footman]

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 

[Trudy Claspill]

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]

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()