Filter to find issues with a comma in a Custom Field

unknown

Hi,

We use a text Custom Field to store a charge numbers. This field must contain a comma to be a valid charge number. I want to find issues with invalid charge numbers so I wrote this filter:

"Charge Number" !~ ','

The filter query is valid but it returns every issues that have a value in the Charge Number field. On the other hand

"Charge Number" ~ ','

returns nothing.

I tried using the unicode number (\u002c) with the same results. 

Do you know how to write this query?

Thanks!

Vasiliy Zverev

There is a trouble for JIRA to search with ~ when firt simbols are not spesified (https://confluence.atlassian.com/jira/performing-text-searches-185729616.html and https://jira.atlassian.com/browse/JRA-6218)

For out needs I use this SQL statement (for MS SQL )

Select
      project.pkey + '-' + CAST( jiraissue.issuenum as varchar(20)) as issueKey
      , customfieldvalue.*
from
      customfield 
      join customfieldvalue   
            join jiraissue    
                  join project      on    jiraissue.PROJECT = project.ID
            on    customfieldvalue.ISSUE = jiraissue.ID
      on customfield.ID = customfieldvalue.CUSTOMFIELD
where
      customfield.cfname = '№ док'
      and customfieldvalue.STRINGVALUE like '%,%' --