Finding issues with ∑ sigma character/symbol in the summary

[Daniel Schaeffer]

Is it possible to find all issues with a sigma character (∑) in their summary?

[Moses Thomas · Accepted solution]

@Daniel Schaeffer

Syntax  issueFieldMatch(Subquery, Fieldname,  reg ex)

To find all tickets  with sigma character use this JQL  query

issueFunction in issueFieldMatch("project is not empty", "summary", "∑")

Best!

[Daniel Schaeffer]

Moses, do I need some specific plugin to do this?  I'm getting a "Field 'issueFunction' does not exist or you do not have permission to view it." error.

Thanks,

Dan

FWIW, this is our license information

License Information for JIRA

JIRA v7.2.8

Copyright © 2002 - 2017 Atlassian Corporation Pty Ltd.

The use of this product is subject to the terms of the Atlassian End User Agreement, unless other specified therein.

This product includes software developed by the Apache Software Foundation.

This product also includes the following libraries which are covered by the GNU LGPL license:

• atlassian-image-consumer (com.atlassian.image:atlassian-image-consumer:1.0.1:jar)
• carol (carol:carol:1.5.2:jar)
• carol-properties (carol:carol-properties:1.5.2:jar)
• datafile (datafile:datafile:1.3.3:jar)
• hibernate (hibernate:hibernate:2.1.8-atlassian:jar)
• image4j (org.jclarion:image4j:0.7:jar)
• JCaptcha (com.octo.captcha:jcaptcha-api:2.0-alpha-1:jar)
• JCaptcha (com.octo.captcha:jcaptcha:2.0-alpha-1:jar)
• jcommon (jfree:jcommon:1.0.8:jar)
• jfreechart (jfree:jfreechart:1.0.13:jar)
• JSCalendar (1.0)
• jStyleParser (net.sf.cssbox:jstyleparser:1.16-atlassian-1:jar)
• Streaming API for XML (javax.xml.stream:stax-api:1.0-2:jar)
• TinyMCE-TinyMCE (4.4.0)
• xapool (xapool:xapool:1.3.1:jar)

[Moses Thomas]

@Daniel SchaefferYou need the  script runner plugin  https://marketplace.atlassian.com/apps/6820/scriptrunner-for-jira?hosting=server&tab=overview

 And make sure that  you  have the Browse project permission in all  projects/  permission in issues security if it exit in projects  so that you   search for issues in the search  dialog.

 Best!

[Damián Sánchez Moreno]

Once again ScriptRunner to the rescue, maddening. I mean I'm happy that someone other than Atlassian is on the ball. Must be nice having access to it xD.