Custom Field Syntax for a Custom Field (Text) to emulate an "IN" operator ?

Dave Johnson

I'm attempting to build a filter which would search JIRAs on a custom field ('External ID") and supply a List of  values .  Here is what I've tried:

1. project = MEMJ AND "External Issue ID" In  ("1734", "1753") ORDER BY cf[10380] ASC  
2. project = MEMJ AND "External Issue ID" ~  ("1734", "1753") ORDER BY cf[10380] ASC 

Operator '~' does not support the list value '("1734", "1753")' for field 'External Issue ID'.

 

Any suggestions ?

Alexey Matveev

Hello,

You can not do it with a text custom field. If you have Adaptivist ScriptRunner you could try to do it with issueFiledMatch JQL function wher you can set a regex expression

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_regular_expressions