Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

...

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.

...

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

Info

Available in Orgwise V4.6.0 or later.

...