Search epic by Epic Name (string contains)?

[Tim Yeung]

We are using the JIRA Agile field "Epic Name".

An example value of "Epic Name" is "Test 123".

Are there anyway in JQL to search for all epics where its "Epic Name" contains "Test"?

Currently, I can only do "Epic Name" = "Test 123"...

Thanks in advance.

[Kirstin Seidel-Gebert · Accepted solution]

Hi Tim,

that seems to be possible using the Script Runner for JIRA add-on, see http://stackoverflow.com/questions/23795108/query-jira-versions-using-wildcards-with-jql.

Cheers,
Kirstin

[Tim Yeung]

Thanks for the reply. Script Runner is really a powerful and useful plugin, and its free. But we don't want it to be deployed in production, as we have a feeling that the Groovy interacts with JIRA backend in a 'too powerful' manner, raising some security concerns (although, maybe, we are wrong, and overreacting).

[Ollie Guan]

Much to my regret, I think this can't do in JQL  

The "~" operator is used to search for issues where the value of the specified field matches the specified value (either an exact match or a "fuzzy" match — see examples below). For use with text fields only, i.e.:

But custom fields which use the "Free Text Searcher"; this includes custom fields of the following built-in Custom Field Types

• • Free Text Field (unlimited text)
  • Text Field (< 255 characters)
  • Read-only Text Field