Using JQL to report on issues reassigned by Out of Office

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:

• 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:

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

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.