Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

jql syntax for a string of variables

Alyssa Hill February 7, 2024

Hi there, I need to create a queue that searches for a specific value that has a string of numbers included in a text field. For example, the description field may contain text of:

Project xyz -VCTSI1234. 

Project abc -VCTSI1111

I need to pull in any ticket that comes through where the text contains

-VCTSI regardless of the string of text that comes before or after the 'I' 

I've tried to use the same setup we have in one of our automation rules, but it's coming back is invalid: 

text ~ -vctsi or text ~ -vctsi

 

I've also tried the below individual statements:

text ~ "-VCTSI (\d+)"

 

Here is the automation statement that works w/ success with a different custom field: 

{{issue.description.match("PID (\d+)")}}

 

Thank you! 

Alyssa Hill 

1 answer

0 votes
Laura Campbell _Seibert Media_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 8, 2024

Hi @Alyssa Hill , JQL and Automation don't work the same way, and text search with JQL is notoriously underwhelming.

I would suggest you set up a new Automation rule similar to the one that works to set a custom field value for the VCTSI requests. You could then much more easily create a filter for your queue based on the custom field value.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events