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 · Accepted solution]

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

[Gergely Groupama]

Hello, Vamsi,

I really like you... :D

The solution works like a charm!

Thank you ever so much!

Best regards,

Greg

[Vamsi Kandala]

Hi @Gergely Groupama

Thank you.  Glad that it worked out for you.

Regards,
Vamsi