2.5 JQL Extension and Custom Department Field

Owned by Junfeng Liu
Last updated: Apr 03, 2024 by Xing Guo
4 min read

Extension of JIRA query language (JQL)

JQL Function: Dept()

Orgwise provides the Dept method for JQL, which can query issues by department for the personnel related to issues.

Name

Dept

Parameter

Department name wrapped in double quotation marks. Allow multiple department parameters.

Operator

in

JQL fields

assignee、reporter、worklogAuthor、custom fields of User Picker

Function

Returns the direct members of given departments, can be matched with the user field value of issues.

Note: If member A is a direct member of department B, and department B is a sub-department of department C, member A cannot be matched to Dept ("department C").

Note: If a member is directly under multiple departments, he can be matched with any of these departments by Dept function.

Sample:

In Issues > Search for issues > Advanced. Enter the advanced search mode on the “Search Issues” interface.

For example, enter assignee in Dept("IT", “HR“) in the search box, and click "Search" to get a list of issues belonging to the assignees in IT and HR Department.

JQL Function: Depts()

Orgwise provides the Depts method for JQL. Depts() is the same as Dept() but including sub-department members, can query issues by department for the personnel related to issues.

Name

Depts

Parameter

Department name wrapped in double quotation marks. Allow multiple department parameters.

Operator

in

JQL fields

assignee、reporter、worklogAuthor、custom fields of User Picker

Function

Returns the members of given departments and their sub-departments, can be matched with the user field value of issues.

Note: If a member is under multiple departments, he can be matched with any of these departments by Depts function.

Sample:

In Issues > Search for issues > Advanced.

JQL Function: OrgMemProp()

Orgwise provides the OrgMemProp method for JQL, which can query issues by member properties for the personnel related to issues.

Name

OrgMemProp

Parameter

Member property name wrapped in double quotation marks. Allow multiple property parameters.

Note: Only supports member properties of single and multiple selection types

Operator

  • in

  • not in

  • is EMPTY

  • is not EMPTY

Supports AND and OR queries for multiple member properties.

JQL fields

assignee、reporter、worklogAuthor、custom fields of Single and Multi User Picker

Function

Returns the members of given member properties, can be matched with the user field value of issues.

Sample:

For example, enter assignee in OrgMemProp("HireType in (External) AND Location in (London,Washington)") in the search box, and click "Search" to get a list of issues belonging to the assignees who are hired externally and works in London or Washington.

Attention:

If the field name contains spaces, for example: "Hire Type", with spaces in between, the field needs to be enclosed in quotation marks, which need to be escaped with a "\" backslash. The correct way to write it is: assign in OrgMemProp ("\" Hire Type \ "in (External) AND Location in (London,Washington)")

Custom Department Field

Department of User

Orgwise provides the field types of "Department of User". The value of this field is equal to the corresponding department of the user associated with a user field in the issue.

You might use it in the following scenarios:

  • Displaying the department of reporters, the department of assignees, and the department of the leaders on Issue View Screen.

  • Exporting issues with department the person belongs to.

  • Searching issues by the department to which the person belongs.

  • Statistics by department the person belongs to in Gadgets.

Add the fields in ⚙ > Issues > Custom fields > Add custom field > Advanced.

After adding this field, you need to enter the configuration interface of the field and set the following:

  1. Specify which user field it corresponds to. You can select "Assignee", "Reporter", or a User Picker (single user) type of custom field.

  2. Select the department to display. It can be set to correspond to a specific department at a certain level of the user, or it can be set to display the complete department path of the user.

Dpartment Picker Fields

Available in Orgwise V4.6.0 or later.

Orgwise provides the field types of "Department Picker (multiple departments)" and "Department Picker (single department)". User can select one or multiple departments from existing organizations as field values.

After adding this field, you need to enter the configuration interface of the field to setcorresponding options:

 

 

Department pickers can be used not only for editing and viewing issues, but also for issue search and statistics in gadgets.