| Table of Contents |
|---|
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.
...
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.
...
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 |
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.
...
Custom Department Field
Dpartment 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.
...
Specify which user field it corresponds to. You can select "Assignee", "Reporter", or a User Picker (single user) type of custom field.
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. |
...