Get started

Use case library

JWT expression editor

JWT expression parser functions

JWT workflow functions

JWT remote actions

JWT automation rules

JWT calculated fields

JWT calendars

JWT properties

JWT JQL functions

Cloud migration hub

Additional product info

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

Use caseJQL function
List all bugs where the current user was mentioned in a comment

issueSelection()

List all issues that are blocking issues that are due soonlinkedTo()
List all issues with an inactive assignee and that were assigned by the current user

issueSelection()

List all issues with a specific value matching a custom text field

issueSelection()

Retrieve all tickets assigned to a developer

usersWithRoleInProject()

Return all issues in the currently open sprint with unresolved sub-tasks

issueSelection()

If you still have questions, feel free to refer to our support team.