Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Dave Johnson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 14, 2017

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 ?

1 answer

0 votes
Alexey Matveev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 14, 2017

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events