projectsWhereTextProperty() | Decadis App Help Center

This JQL function returns projects with specific properties containing a text value.

Syntax

Bash

projectsWhereTextProperty(propertyName, operator, value) #Output: Text list

Examples

Parser expression	Description
Bash `project in projectsWhereTextProperty("country", "=", "Spain")`	This example returns a list of projects where the project property country is equal to Spain, i.e. text {country=Spain} is present in the project's description.
Bash `project in projectsWhereTextProperty("country", "matches","France\|Germany")`	This example returns a list of projects where the project property country matches the regular expression France\|Germany, i.e. text {country=France} or {country=Germany} are present in the project description.
Bash `project in projectsWhereTextProperty("country", "~", "spain")`	This example returns a list of projects where project property country is equal to spain, SPAIN, SpAiN, etc.

Additional information

Parameters used in this function

Parameter	Input (data type)	Description
`propertyName`	text	The name of a project property containing a text value.
`operator`	TEXT	A valid comparison operator.
`value`	text	The text value used for searching or a regular expression in the case of the `matches` operator.

Output

This function returns a text list

The result is not what you expected? The number of returned issues feels too low?

By default, the maximum number of issues that will be returned by the JQL subquery, and thus can be processed by the logical expression is 1000.

To ensure the performance of your entire Jira instance, we limit the execution of the JQL function in terms of issue count and execution time. Please refer to your admin if you need to change the Performance settings .