projectsWhereTextProperty()

This function is used for searching text or string values in project properties.

Syntax

projectsWhereTextProperty( project_property, operator, string_literal | regular_expression ) #Output: Project list

Parser expression	Description
projects in projectsWhereTextProperty( country, "=", Spain )	This example returns a list of projects where property 'country' is equal to 'Spain', i.e. string {country=Spain} is present in the project's description.
projects in projectsWhereTextProperty( country, matches, "France\|Germany" )	This example returns a list of projects where property 'country' matches the regular expression France\|Germany, i.e. string {country=France} or {country=Germany} are present in the project description.
projects 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
`project_property`	TEXT	The name of a project property containing a text or string value.
`operator`	DATA TYPE	Comparison operator to be applied. "=" strict equal operator. "!=" strict not an equal operator. "~" approximate equal operator (case insensitive and trims blanks). "!~" approximate not equal operator (case insensitive and trims blanks). "`matches`" The value of project property matches a regular expression. "`doesn't match`" The value of project property doesn't match a regular expression. ">, >=, <, <=" lexicographical order operators.
`string_literal \| regular_expression`	TEXT	A string literal used for comparison, or a regular expression in the case of `matches` operator.

This function returns a PROJECT LIST