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 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`		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