JQL how to search Summary field containing a comma character(,)

[Eugenia Fernandez Fariña]

As export won't let change the separator character, and forces always a comma(,), I need to identify all summary fields containing one or more comma

[Bill Sheboy]

Hi @Eugenia Fernandez Fariña -- Welcome to the Atlassian Community!

I do not believe that is possible with JQL.

According to this documentation, comma is a restricted character, which can be wrapped in quotation marks or preceded with a double-backslash to search.

https://support.atlassian.com/jira-software-cloud/docs/what-is-advanced-search-in-jira-cloud/#Restricted-words-and-characters

But that does not work as documented, according to this backlog suggestion:

https://jira.atlassian.com/browse/JRACLOUD-75866

The only consistent suggestion was instead to search for an exact phrase which does not contain the character...which will not help in your scenario.

Kind regards,
Bill

[Hannes Obweger - JXL for Jira]

Hi @Eugenia Fernandez Fariña

I don't know if this problem justifies additional tooling for you, but just to put it out there: If you're open to solutions from the Atlassian Marketplace, you'll find a number of apps that can help here.

E.g., my team and I work on an app in which your use case would be easy to solve: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. For text filtering, JXL uses a different technology than Jira, meaning that you can sort by any characters, and even by regular expressions for more advanced use cases. This is how it looks in action:

I should add that JXL can do much more than that: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

[BHUSHAN PATIL]

Hi @Eugenia Fernandez Fariña ,

You can use the tilde (~) operator with double quotes to find issues where the Summary field contains a comma (,)character.

Here's how you can do it:

summary ~ ","

By applying this JQL query, you will be able to filter and retrieve issues in Jira Cloud where the Summary field contains a comma character.

Regards,
Bhushan

[Trudy Claspill]

@BHUSHAN PATIL 

I tried that in my instance and it did not work.

Does it actually work in your instance?

[Eugenia Fernandez Fariña]

I had tried that, as well as ~ ",*" and it didn't work. That's why I asked here. Did you try that and it worked for you?