Get started

Use case library

JWT expression editor

JWT expression parser functions

JWT workflow functions

JWT remote actions

JWT automation rules

JWT calculated fields

JWT calendars

JWT properties

JWT JQL functions

Cloud migration hub

Additional product info

Versions Compared

Old Version 1

changes.mady.by.user Iheb Kharab

Saved on

compared with

New Version 2

changes.mady.by.user Iheb Kharab

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


UI Text Box
sizemedium
typeinfo

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



Code Block
languagebash
titleSyntax
linenumberstrue
projectsWhereTextProperty( project_property, operator, string_literal | regular_expression ) #Output: Project list


UI Expand
titleExamples


Parser expressionDescription


Code Block
languagebash
linenumberstrue
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.


Code Block
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.


Code Block
projects in projectsWhereTextProperty( country, "~", spain )


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



UI Expand
titleAdditional information

Parameters used in this function

ParameterInput (data type)Description
project_property

Status
subtletrue
titletext

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

Status
subtletrue
titledata type

Comparison operator to be applied.

Expand
titlemore info...
  • "=" 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

Status
subtletrue
titletext

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



UI Expand
titleOutput

This function returns a

Status
subtletrue
titleProject list