On this page
Use case
Retrieve all issues which belong to the projects PLAT and WEB, whose assignee is not active anymore and in which the current user was an assignee in the past.
Configuration
Use the following JQL:
issue in issueSelection("project in (PLAT, WEB)", "!isActive(%{issue.assignee}) and %{system.currentUser} in fieldHistory(%{issue.assignee})")
Details to keep in mind
To set the subquery, it is recommended to test it beforehand in the issue navigator. The less issues returned by the subquery, the faster the function will be executed, so the more precise the subquery, the better.
To further refine the issues returned, the following functions are used:
- isActive() to check whether the current assignee is an active user
- fieldHistory() to query the field history of the assignee field
Screenshots
Related use cases
If you still have questions, feel free to refer to our support team.