Building a JQL of issues with assignees changed by Out of Office

JQL can look up which issues have had their assignees changed by the app. In order to do this, the app must be called with the ID "59fb203e1c0767667b2ce0ad".

Here's a full example of the syntax for these queries:

assignee CHANGED BY "59fb203e1c0767667b2ce0ad" AFTER "date1" BEFORE "date2" FROM "username1" TO "username2"

• The JQL must contain the expression "assignee CHANGED BY "59fb203e1c0767667b2ce0ad"
• The AFTER and BEFORE parameters are optional and can be used to track assignee changes over a specific period of time
• The FROM and TO parameters are also optional. 

Building reports that capture Out of Office reassignments

Using native Jira gadgets

Here are some examples of reassignment reports built with Jira native gadgets:

	Chart
Gadget Filter results Use Case Full list of issues reassigned by Out of Office
Sample Query	assignee CHANGED BY "59fb203e1c0767667b2ce0ad" CODE
Gadget Two Dimensional Filter Statistics Use Case Identify how issues are being reassigned across the company Explore this chart! There are many combinations available (Creator, Epic Link, Sprint, Category...)
Sample Query	assignee CHANGED BY "59fb203e1c0767667b2ce0ad" CODE
Gadget Pie Chart Use Case Track the progress of reassigned issues
Sample Query	assignee CHANGED BY "59fb203e1c0767667b2ce0ad" BEFORE "date2" AFTER "date1" CODE
Gadget Pie Chart Use Case Track the reassigned workload per coverer
Sample Query	assignee CHANGED BY "59fb203e1c0767667b2ce0ad" BEFORE "date2" AFTER "date1" CODE
Gadget Issue statistics Use Case Track the reassigned workload per coverer
	assignee CHANGED BY "59fb203e1c0767667b2ce0ad" BEFORE "date2" AFTER "date1" CODE
Gadget Two Dimensional Filter Statistics Use Case Creator to Coverer Path You can restrict how many coverers are shown with the TO parameter
Sample Query	assignee CHANGED BY "59fb203e1c0767667b2ce0ad" TO "{userID of coverer}" CODE
Gadget Pie Chart Use Case Assignee to Coverer Path
Sample Query	assignee CHANGED BY "59fb203e1c0767667b2ce0ad" from "{user ID of original assignee}" CODE
Gadget Issues Calendar Use Case Reassignment Calendar
Sample Query	assignee CHANGED BY "59fb203e1c0767667b2ce0ad" CODE
Gadget Created vs Resolved Chart Use Case Track whether reassigned issues are being taken care of
Sample Query	assignee CHANGED BY "59fb203e1c0767667b2ce0ad" CODE

Using Custom Charts for Jira

Out of Office reassignments can be read by any reporting apps from the Atlassian Marketplace, like Custom Charts for Jira, that support JQL expressions.

A main advantage of Custom Charts for Jira is the ability to connect any number of gadgets to a Simple Search gadget, such that the charts display different statistics on the JQL and filters applied to the Simple Search.

See the example below:

For more inspiration, you can read a blog article on 14 dashboard gadgets to nail capacity planning in Jira with Custom Charts.