JQL Functions
linkedIssuesFromFilter()
Finds all issues which are linked by specified relation with those found by saved filter. When relationDirection is provided then relation should also be provided.
When recursionNumber is specified then issues linked to found linked issues are also considered as a result.
Parameters:
- filter - could be given by name or its id.
- relation - is optional and given by name (about relation parameter more information in FAQ section), name of relation (or relation description) must match names that are set in configuration, by default they start with capital letter see more
- relationDescription avilable since version 2.10.0 (about relation description parameter more information in FAQ section), must match descriptions that are set in configuration, see more
- relationDirection - optional, have values inward or outward (do not provide if you choose direction by relation description)
- recursionNumber - optional, have positive integer values (not supported with relation description parameter)
Syntax:
Examples:
linkedIssuesFromQuery()
Finds all issues which are linked by specified relation with those found by JQL. When relationDirection is provided then relation should also be provided.
When recursionNumber is specified then issues linked to found linked issues are also considered as a result.
Parameters:
- JQL- could be given by JQL query
- relation - is optional and given by name (about relation parameter more information in FAQ section), name of relation (or relation description) must match names that are set in configuration, by default they start with capital letter see more
- relationDescription avilable since version 2.10.0 (about relation description parameter more information in FAQ section), must match descriptions that are set in configuration, see more
- relationDirection - optional, have values inward or outward (do not provide if you choose direction by relation description)
- recursionNumber - optional, have positive integer values (not supported with relation description parameter)
Syntax:
Examples:
parentIssuesFromFilter()
Finds all issues which are parents of subtasks issues selected by specified saved filter.
Parameters:
- filter - could be given by name or its id.
Syntax:
Examples:
parentIssuesFromQuery()
Finds all issues which are parents of subtasks issues selected by JQL.
Parameters:
- JQL- could be given by JQL query
Syntax:
Examples:
subtaskIssuesFromFilter()
Finds all issues which are subtasks of issues selected by specified saved filter
Parameters:
- filter - could be given by name or its id.
Syntax:
Examples:
subtaskIssuesFromQuery()
Finds all issues which are subtasks of issues selected by JQL
Parameters:
JQL- could be given by JQL query
Syntax:
Examples:
numberOfLinkedIssuesFromQuery()
Finds all issues which number of linked issue meet a condition. Relation type and direction is not analyse by function so all linked issues are proceeded to check condition. Query has three required parameters.
Parameters:
- JQL- JQL query to analyse.
- mathematicalSymbol- available symbols ==, <=, !=, >=, >, <
- numberOfLinkedIssues- number of linked issues
Syntax:
Examples:
numberOfLinkedIssuesFromFilter()
Finds all issues which number of linked issue meet a condition. Relation type and direction is not analyse by function so all linked issues are proceeded to check condition. Query has three required parameters.
Parameters:
- filter - could be given by name or its id.
- mathematicalSymbol- available symbols ==, <=, !=, >=, >, <
- numberOfLinkedIssues- number of linked issues
Syntax:
Examples:
having...()
having...
counterparts:havingLinkedIssuesFromQuery(...)
,
havingLinkedIssuesFromFilter(...)
,
havingSubtaskIssuesFromQuery(...)
,
havingSubtaskIssuesFromFilter(...)
,
havingParentIssuesFromQuery(...)
,
havingParentIssuesFromFilter(...)
.
havingXXXX("subquery")
is equivalent to: reversedXXX("") and subquery
, (where ""
is a subquery which matches all the issues).
returns those issues which are parents of some subtask issues, and contain linux
text somewhere. This is equivalent to (but faster than) this query:
Note that this is not the same as query:
which returns parent issues of subtask issues containing linux (returned parents themselves don't have to contain linux
).
having...
queries work.epicsFromFilter()
Function will return all Epics that where assigned to issues returned by given filter parameter.
Function allows you to discover all Epics that where used in your issue set. In this case issue set is defined as filter.
Parameters:
- filter - could be given by name or its id.
Syntax:
Examples:
epicsFromQuery()
Function will return all Epics that where assigned to issues returned by given query parameter.
Function allows you to discover all Epics that where used in your issue set. In this case issue set is defined as query.
Parameters:
- JQL- could be given by JQL query
Syntax:
Examples:
epicsWithIssue()
Function will returned all Epics that have at least one issue assigned. Function will search for all Epics in your JIRA instance.
Parameters: no
Syntax:
Examples:
epicsWithoutIssue()
Function will returned all Epics that have no issues assigned. Function will check all Epics in your JIRA instance.
Parameters: no
Syntax:
Example: