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

Eugenia Fernandez Fariña
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!
March 20, 2024

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

3 answers

2 votes
Bill Sheboy
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.
March 20, 2024

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

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 21, 2024

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:

text-search-comma.gif

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

0 votes
BHUSHAN PATIL
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.
March 20, 2024

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 20, 2024

@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'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 20, 2024

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?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events