How can I use regex in a JQL query? I cannot match strings that have a specific ending in JQL (ex: *ing ; should match running, jogging, etc.)...

[Eric Gross]

Is there a way to use regex in JQL? If not, is there a way to use a wildcard character at the begining of a string? When I use the following to match any issues that contain "Citrix", I recieve the following error:

 project="SPDM" AND status="open" AND summary~"*Citrix" AND summary~"Requests"'

 Query validation failed: The text query '*' for field 'summary' is not allowed to start with '*'.

I'm using the JQL for queries I am making with a SOAP client (I know SOAP is being replaced by REST, but I am sticking with it for now). Is it possible to use the wildcard this way? I can run the query like this to get some results; but it doesn't match results like DEVCitrix, PRODCitrix:

project="SPDM" AND status="open" AND summary~"Citrix" AND summary~"Requests"'

I would prefer to stay away from plugins if possible...

Thanks

[rafaferreira]

For any heavy JIRA user, we do need this feature, I don't want to pay more for any other plugin. Atlassian need to provide this feature.

[Kiran01BM]

Thumbs up! I do feel the same, Is anyone aware of a feature request raised for this ?

[swapna.ragi]

I totally agree with this, why should we pay more for this

[Julia T]

 Script Runner plugin will help
See comments below

[Mark Symons]

Try the Script Runner plugin. Yes. I know you would prefer to stay away from plugins - but Script Runner is currently free.

The newly-introduced (still Beta) JQL regex offers a issueFieldMatch function that looks like it might help.

[Jozef Kotlár]

• no - regular expressions are not supported by JQL -see documentation
• no - wildcard cannot be on the beginning

Both are restrictions of used searching engine - Lucene.

[Nick]

Yes, "Script Runner" is good. For example you can matching projects by name pattern

e.g.  project in projectMatch("Dev - *")

See previous answer

Also have a look at what you can do matching text fields too (https://confluence.atlassian.com/jira/performing-text-searches-185729616.html)

[Mark Risman]

That seems helpful if you're searching in projects, but the link here for text searches does not currently explain how to search using a regular expression