How to search for multiple values in one field

Jamie_z6oszz

I have a custom field to identify customers, each value is 7 characters (3 for country, 1 underscore, and 3 for Bank). I want to search the customer field for all tickets where the customer ends with XYZ. Or I can enter each customer value but cannot get the syntax correct. project = "project" and custom field = ?

Heiko Gerlach

Hi Jamie is this a text customfield or Select?

 

In case it is text you can use the jql % operator, since you have the under score in your text, simply ask something like

customfield_xxx ~AAA_% to match the country or ~%_NNN for the bank, where AAA is the country code you ar looking for and NNN is the bank.

 

Cheers

Heiko Gerlach

Accxia