HOw to search for issue where custom field contains part of a string ?

Question

Dear all,

I have a custom field which is a list box field of text.

When user create a ticket he select from that list box the proper item

What I need to do from an Automation rul is to check as a condition that :

IF my_CustomField contains "ABC", then I should do an Action

Typically, all the follwing value of my field should return true :

my_CustomField = 123-ABC9993383

my_CustomField = ABC9993383

my_CustomField = 9993383ABC

What is the proper syntax to build that rule JQL condition ?

I have tried the following :

my_CustomField ~"*ABC* which should cover all case

But when I test this in search issue query, I have an error saying that "*" are not supported.

What is the proper way to do this search ?

regards

Nic Brough -Adaptavist- · Answer

It's the same answer I already gave, either sort out the product identification into sane fields (either split into more fields to avoid the customers silly naming scheme, or turned into a text field because that's how you want to use it).

@mauricio.groth also gives you a solution without having to set your fields up properly.

mauricio.groth · Answer

Hi @Calderara Serge

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to filter your issues where a custom field contains part of a string

issue in wildcardMatch("my_CustomField", "ABC*")

The star symbol can be placed anywhere in the text – you can even place more than one.

Check out the documentation for more examples.
I hope this helps!
Maurício

Calderara Serge · Answer

@Nic Brough -Adaptavist- , thanks for your reply

This is the way my customer is working base on its product Type name and I cannot change their identification

In fact when they have selected the product name in the list for exemple :

123ABCD45678, in fact out of this name, the caracters at position 2,3,4 is the product type group

From an automation IF I need to check this product type ID out of this string in order to populate an other field with the type

For exemple I have define a IF condition in Automation as below

From my rule above, that means if my field contains in 2,3,4 position the string M22, then I will edit an other field in the form and set it to HB2

This works fine for one condition but what I need to to check different value as below

IF {{issue."Charging Station SN".substring(1,4).capitalize()}} EQUAL M22
OR {{issue."Charging Station SN".substring(1,4).capitalize()}} EQUAL M23

THEN myType = HB2

I could not find a proper condition which allows be to implement this in Automation

Any idea ?