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 "userID1" TO "userID2"
CODE
  • 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


GadgetFilter results
Use CaseFull list of issues reassigned by Out of Office





Sample Query

assignee CHANGED BY "59fb203e1c0767667b2ce0ad"
CODE


GadgetTwo Dimensional Filter Statistics
Use CaseIdentify 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


GadgetPie Chart
Use CaseTrack the progress of reassigned issues




Sample Query
assignee CHANGED BY "59fb203e1c0767667b2ce0ad" BEFORE "date2" AFTER "date1" 
CODE


GadgetPie Chart
Use CaseTrack the reassigned workload per coverer




Sample Query
assignee CHANGED BY "59fb203e1c0767667b2ce0ad" BEFORE "date2" AFTER "date1" 
CODE
GadgetIssue statistics
Use CaseTrack the reassigned workload per coverer

assignee CHANGED BY "59fb203e1c0767667b2ce0ad" BEFORE "date2" AFTER "date1" 
CODE


GadgetTwo Dimensional Filter Statistics
Use CaseCreator 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
GadgetPie Chart
Use CaseAssignee to Coverer Path

Sample Query
assignee CHANGED BY "59fb203e1c0767667b2ce0ad" from "{user ID of original assignee}"
CODE
GadgetIssues Calendar
Use CaseReassignment Calendar

Sample Query
assignee CHANGED BY "59fb203e1c0767667b2ce0ad"
CODE
GadgetCreated vs Resolved Chart
Use CaseTrack 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.