nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL numeric string summary matching

Jordan Wolman

Hello,

I'd like to set up an automation rule that links a newly created ticket to an existing ticket IF the first 10 digits (numeric) of the summary match those of an existing ticket. I've tried several ways to do this with no success.

My current rule:

Trigger: Newly created issue

Then lookup issues: summary ~ "^\\d{10,}"

Then link issues

My JQL query in the lookup issues step is saying "Unable to parse the text '^\d{10,}' for field 'summary'. " but I'm struggling to determine what is wrong.

Accepted answers

Trudy P Claspill

Hello @Jordan Wolman

From where did you get the idea that you could use that sort of syntax in a JQL?

This document discusses what is valid to use when searching a text field:

https://support.atlassian.com/jira-software-cloud/docs/search-syntax-for-text-fields/

All comments

Trudy P Claspill

Hello @Jordan Wolman

From where did you get the idea that you could use that sort of syntax in a JQL?

This document discusses what is valid to use when searching a text field:

https://support.atlassian.com/jira-software-cloud/docs/search-syntax-for-text-fields/

Jordan Wolman

Thank you from sharing - I do not see a section in this article that discusses dynamic searches i.e. matching a string by an ID number or name. I'm assuming what I was trying to accomplish is not possible.

Trudy P Claspill

JQL criteria for text fields does not support the use of regex.

You said you are trying to match the first 10 digits from the newly created issue Summary against other issues. Are the digits the first 10 characters in the summary?

If so, then you could use the left() function to pull the first 10 characters.

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-text-fields/#left-int-length-

You could then use that in your Lookup with or without (as you deem necessary) the wildcards that are supported for criteria for text fields:

summary ~ "{{issue.description.left(10)}}"

Jordan Wolman

Hi Trudy - yes the digits are the first 10 characters of the summary.

I would like for when a new issue is created, the automation rule to search for a match of those first 10 characters and if one is found, link said tickets. I'm having trouble determining what actions/condition steps to create for this though. I tried...

When: Issue created
Then: lookup issues using {{issue.summary.left(1)}}
Then: Link issue to trigger issue

Do you have a recommendation for how I should create the rule details?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-core

jql