wildcard search project specific select field in jql

[Alexander SCHENK]

Hello, I have to search overall projects all issues with the customfield value (it is a Project Specific Select Field) including a specific string (for example XXX). There are hundreds of combinations from the specific string in the customfieldvalue and therefore I will not include them all with customfieldvalue in ("AB XXX", "AAC XXX1", AG XXX3 ...)

Is it possible in jql? If not, which table can I search in database with SQL statement and like %XXX%?

Best regards

[Holger Schimanski]

In JQL for select custom fields there is no wildcard search possible. For SQL you find some information here. https://confluence.atlassian.com/jirakb/to-find-or-view-a-jira-issue-from-the-database-using-sql-744524576.html

Hope this helps. Or do you need more details?

Best regards, Holger

[Alexander SCHENK]

Is it possible to implement this as a feature?

[Holger Schimanski]

Not planning to implement specific JQL for Project Specific Select Fields.

Best regards Holger