projectsWhereTextProperty()

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

Syntax

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

Parser expression	Description
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.

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.

This function returns a TEXT LIST