Status
Tech review



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



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



Parser expressionDescription


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

ParameterInput (data type)Description
project_property

The name of a project property containing a text or string value.
operator

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

A string literal used for comparison, or a regular expression in the case of matches operator.



This function returns a