Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

RegEx not supported by CQL search for the field "title"?

Thorsten Rabel
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 28, 2018

Hello,

 

I tried in vain to establish a CQL search string for a page title starting with a specific letter.

The basic CQL Search ...

type = "Page" and space = "[space name]" and ancestor = [page id] and title ~ "E*"

... lists all sites with a word starting with letter "E" anywhere in the title (i.e. both "Export Control Officer" and "Process Expert")

I have tried to replace the search string "E*" by a regular expression (RegEx) /^E.*$/  without sucess both in text and in unicode, both in quotation marks and without, both with exact search "=" and fuzzy search "~".

Is RegEx not supported by CQL search for the field "title"?

 

Work around would be to use tags which would require an manual step which I would like to avoid as there are many different authors and a page title is mandatory anyway.

1 answer

0 votes
Manuel Kummerländer
Contributor
November 13, 2019

Hi,

if it's still an open question ...
In the search field you could try

title:'/E.*/'

Using the search API itself you could try

 title ~ '/E.*/'

As I know the quotes are important :)

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events