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
  • relationis 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...()

All the above functions have their  having...  counterparts:

havingLinkedIssuesFromQuery(...),  

havingLinkedIssuesFromFilter(...),  

havingSubtaskIssuesFromQuery(...)

havingSubtaskIssuesFromFilter(...)

havingParentIssuesFromQuery(...),  

havingParentIssuesFromFilter(...).

 

Those functions do the same task as the previously-existing functions, but return not the link 'targets', but link 'sources' that generated the targetshavingXXXX("subquery") is equivalent to: reversedXXX("") and subquery, (where "" is a subquery which matches all the issues).

For example:

 

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).


Similarly other 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: