This JQL function is used for searching project properties containing a text value.

Syntax
projectsWhereTextProperty(propertyName, operator, value) #Output: Issues
Examples
Parser expressionDescription
project in projectsWhereTextProperty(country, "=", Spain )
This example returns a list of projects where the property 'country' is equal to 'Spain', i.e. text {country=Spain} is present in the project's description.
project in projectsWhereTextProperty(country, matches, "France|Germany")
This example returns a list of projects where property 'country' matches the regular expression France|Germany, i.e. text {country=France} or {country=Germany} are present in the project description.
project in projectsWhereTextProperty(country, "~", spain)
This example returns a list of projects where property 'country' is equal to 'spain', 'SPAIN', ' SpAiN ', etc.
Additional information

Parameters used in this function

ParameterInput (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 PROJECT LIST