How to query for only a part of a select list option?

Gergely Groupama

Hi!

I have a select list custom field with options that contain a two component identifier: a name and a numeric identifier. It looks something like this: XYZ (001).

I would need the option to query for only the numeric value. Currently I can only query for the entirety as the jql will only prompt options when I write XYZ, but will yield no results when trying to look for 001.

I can't for the life of me figure out a solution. Anyone have an idea what I could do?

Thanks

 

Vamsi Kandala

Hi @Gergely Groupama,

If you have ScriptRunner installed, you can make use of 'issueFunction'.

Try this:

issueFunction in issueFieldMatch("project = XYZ", "customfield_xxxxx", "001")

Where, replace 'XYZ' with your project key and replace 'xxxxx' with the id of your custom field.

Hope this helps.

Thanks,
Vamsi