JQL Functions
Summary
Keychain introduces two new JQL functions to your system named delegatesOf() and delegatorsOf().
These JQL functions allow you to filter issues based on delegations defined on the Delegation Configuration page.
delegatesOf() Function
This function returns the current delegate(s) of the given user, according to delegation definitions.
It takes two parameters and returns a list of users that are the delegates of the given user.
| Parameter | Required | Details |
|---|---|---|
| delegator | Yes | The login name of the user that you want to get the delegates for. |
| category | No | The delegation category in which to look for the delegates of the given delegator. If no category is given, the function returns the delegates of the delegator in all categories, including General. If a category is given, the function returns the delegates of the delegator in the given category. Since the General category implicitly includes all other categories, delegations defined in the General category will also be included. If "General" category is given, the function returns the delegates of the given delegator only in the General category. Any category-specific delegates are excluded. |
It can be used on system user fields like:
assignee in delegatesOf("admin")
//This query will return all issues that are currently assigned to one of admin user's delegates in any category, including General.
assignee in delegatesOf("admin", "General")
//This query will return all issues that are currently assigned to one of admin user's delegates only in General category.
assignee in delegatesOf("admin", "Expense")
//This query will return all issues that are currently assigned to one of admin user's delegates in Expense and General categories. It can also be used with custom fields:
"My User Picker" in delegatesOf("admin")
//This query will return all issues that have one of the delegates of admin user (in any category, including General) in its "My User Picker" custom field.
"My User Picker" in delegatesOf("admin", "General")
//This query will return all issues that have one of the delegates of admin user (only in General category) in its "My User Picker" custom field.
"My User Picker" in delegatesOf("admin", "Expense")
//This query will return all issues that have one of the delegates of admin user (in Expense and General categories) in its "My User Picker" custom field.
delegatorsOf() Function
This function returns the user(s) that currently have delegated their permissions to the given user, according to delegation definitions.
It takes two parameters and returns a list of users that have delegated their permissions to the given user.
| Parameter | Required | Details |
|---|---|---|
| delegate | Yes | The login name of the delegate user that you want to get the delegators for. |
| category | No | The delegation category in which to look for the delegators of the given user. If no category is given, the function returns the delegators of the user in all categories, including General. If a category is given, the function returns the delegators of the user in the given category. Since the General category implicitly includes all other categories, delegations defined in the General category will also be included. If the "General" category is given, the function returns the delegators of the given user only in the General category. Any category-specific delegates are excluded. |
It can be used on system user fields like:
assignee in delegatorsOf("admin")
//This query will return all issues that are currently assigned to one of the delegators of admin user in any category, including General.
assignee in delegatorsOf("admin", "General")
//This query will return all issues that are currently assigned to one of the delegators of admin user only in General category.
assignee in delegatorsOf("admin", "Expense")
//This query will return all issues that are currently assigned to one of the delegators of admin user in Expense and General categories.It can also be used with custom fields:
"My User Picker" in delegatorsOf("admin")
//This query will return all issues that have one of the delegators of admin user (in any category, including General) in its "My User Picker" custom field.
"My User Picker" in delegatorsOf("admin", "General")
//This query will return all issues that have one of the delegators of admin user (only in General category) in its "My User Picker" custom field.
"My User Picker" in delegatorsOf("admin", "Expense")
//This query will return all issues that have one of the delegators of admin user (in Expense and General categories) in its "My User Picker" custom field.