JQL Query for Exact Search who assigning the the issues and the date of assignment

[Connie Tsen]

I would like to know if there is any way to construct an advanced search on the following search criteria:

a. Who assigns the assignee?

b. What date was this change made by the person in a?

In other words, I would like to search based on the change log record capturing the person who made changes to the assignee column and the actual date this change took place.

Secondly, I would also be interested to know is there any way i could display this actual change date by the person in item a.

Thirdly, anyone can share me the full reference fields or syntax for the Jira Software advance search for easy reference in future. 

Thank you in advance.

[Trudy Claspill]

Hello @Connie Tsen 

Welcome to the Atlassian community!

Are you working with Jira Cloud, or Jira Server/Data Center?

Here is the documentation for Advanced Search for Jira Cloud.

https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/

And here is the link for the documentation for the latest version of Jira Server/Data Center:

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-939938733.html

There are several elements to advanced searching; functions, operators, fields, and so on. There are multiple pages of documentation to cover all of this.

You can use the CHANGED operator for the Assignee field to filter for issues where the Assignee field was changed. You can add the BY clause to it to get issues where the Assignee was changed by a specific person. And you can add date clauses to it to further filter by changes made On, Before, or After a specific date of within a date range.

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-CHANGEDCHANGED