Skip to main content
assistive.skiplink.to.breadcrumbs
assistive.skiplink.to.header.menu
assistive.skiplink.to.action.menu
assistive.skiplink.to.quick.search

Search

Jira Workflow Toolbox (Server / DC) 3.x

Use case library

JWT expression editor

JWT expression parser functions

JWT workflow functions

JWT remote actions

JWT automation rules

JWT calculated fields

JWT JQL functions

Cloud migration hub

Additional product info

Page History

Versions Compared

Old Version 18

changes.mady.by.user Thorsten Letschert

Saved on Sep 06, 2021

compared with

New Version Current

changes.mady.by.user Iheb Kharab

Saved on Dec 06, 2021

Key

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

UI Text Box

size	medium
type	info

This JQL function can be used to search for issues that satisfy the specified JQL query and logical expression. very powerful JQL function combines the power of classic JQL and JWT, by letting you refine your JQL subquery using a JWT logical expression.

The function works in the following way:

The JQL subquery will be evaluated first and return a number of issues
These issues will then be run against a logical expression
Issues where the expression returns TRUE will be returned by the overall JQL query

Example

Code Block

language	bash
linenumbers	true

issue in issueSelection('project = DESK', '%{issue.subtasks.count} >= 1')

The JQL subquery will return all issues from the DESK project
The logical expression will check whether these issues have at least one sub-task.
The JQL function will only return the issues with sub-tasks.

Code Block

language	bash
title	Syntax
linenumbers	true

issueSelection(subquery, logicalExpression) #Output: Issue list

UI Expand

title	Examples

Parser expression

Description

Code Block

language	bash
linenumbers	true

issue in issueSelection('project = QA', '%{issue.assignee} = %{issue.reporter}')

This example returns all issues within the QA project where the reporter is also the current assignee.

Code Block

language	bash
linenumbers	true

issue in issueSelection('type = Story', '%{issue.subtasks.count} >= 1')

This examples returns all stories that have at least one sub-task.

Code Block

language	bash
linenumbers	true

issue in issueSelection('project = CRM',  'count(allComments()) > 10')

This example returns all issues within the CRM project with more than 10 comments.

To achieve this, the following functions are used:

Code Block

language	bash
linenumbers	true

issue in issueSelection('category = Support', 'count(filterByResolution(subtasks(), "")) > 0')

This example returns all issues from projects within the Support category with unresolved sub-tasks.

To achieve this, the following functions are used:

Code Block

language	bash
linenumbers	true

issue in issueSelection('type = Task', 'isAClone()')

This example returns all Tasks tasks that have been created by cloning an issue.

To achieve this, the following functions are used:

isAClone()

Code Block

language	bash
linenumbers	true

issue in issueSelection('project = KANBAN', 'isInRole(%{issue.assignee}, "Developers")')

This example returns all issues within the KANBAN project that are assigned to users in the Developers role.

To achieve this, the following functions are used:

isInRole()

Code Block

language	bash
linenumbers	true

issue in issueSelection('type = Incident', 'lastFieldChangeTime(%{issue.priority}) > ({system.currentDateTime} - 60 * {MINUTE})')

This example returns all Incidents with a change of priority within the last 60 minutes.

To achieve this, the following functions are used:

lastFieldChangeTime()

Code Block

language	bash
linenumbers	true

issue in issueSelection("type = Bug and resolution = Unresolved", 'matches(%{issue.versions}, ".*EAP.*")')

This example returns all unresolved Bugs with a 'EAP'-labelled version.

matches()

Code Block

language	bash
linenumbers	true

issue in issueSelection("project = HR", '!isActive(%{issue.assignee})')

This example returns all issues within the HR project that are assigned to inactive users.

isActive()

Code Block

language	bash
linenumbers	true

issue in issueSelection("project = JWT", 'matches(%{issue.attachments.details}, "(.*application/pdf.*){1,}")')

This example returns all issues within the JWT project that have at least one PDF file attached.

matches()

UI Expand

title	Additional information

Parameters used in this function

Pro tip: Write the JQL query in single quotes instead of double quotes. Otherwise everytime a double-quotation is used in the subquery, they must be jumped with a slash

The subquery must not be empty to avoid negative performance impacts. Always try to keep the number issues returned by the subquery as minimal as possible.

Pro tip: Write the parser expression in single quotes instead of double quotes. Otherwise everytime a double-quotation is used in the expression, they must be jumped with a slash.

See additional examples and learn how to build logical expressions here.

Parameter Input (data type) Description

subquery

Status

subtle	true
title	text

A JQL query to select the issues that should be further filtered by the logical expression.

UI Text Box

type	tip

logicalExpression

Status

subtle	true
title	text

A logical expression that returns a boolean value.

UI Text Box

type	tip

Include Page

	DECADIS:_snip_proTip_JQL
	DECADIS:_snip_proTip_JQL

UI Expand

title	Output

This function returns a an

Status


subtle	true
title	issue list

Include Page

	DECADIS:_snip_limit_JQL_functions
	DECADIS:_snip_limit_JQL_functions

Image AddedUse cases and examples

Page properties report

firstcolumn	Use case
headings	JQL function
cql	label = "jql_func_issueselection" and space = currentSpace()

Page properties

hidden	true

Short description

Filters Returns issues by a given that satisfy both a JQL query and a JWT logical expression

Output

Status


subtle	true
title	ISSUE LIST

Label

Status


colour	Red
title	staff pick

Page properties

hidden	true

Status

Tech review

Status

colour	Yellow
title	Ready for review

Status

colour	Red
title	flagged

Style guide

Status

colour	YellowGreen
title	Ready for reviewdone

Status

title	todo

Status

colour	Yellow
title	Ready for review

Status

colour	Green
title	done

Status

colour	Red
title	flagged

Powered by Atlassian Confluence 8.5.7, themed by Refined 7.5.3 and Decadis AG