View Source

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

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

Parser expression

Description

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.

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.

project in projectsWhereTextProperty("country", "~", "spain")

This example returns a list of projects where project property country is equal to spain, SPAIN, SpAiN, etc.

Parameters used in this function

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

This function returns a

Short description	Returns projects with specific text properties.
Output
Label

	Status
Tech review
Style guide