I want to search “/“ in Business Sponsor field. Not getting the required results
project = xxxx and (“Business Sponsor” !~ “/“ and “Business Sponsor” !~ “ /“ and “Business Sponsor” !~ “/ “ and “Business Sponsor” !~ “ / “ )
I am not getting required results even tried adding “*” before and after the “/“
We had several times where we had a forward slash or a double forward slash in a string and search is unable to find the slashes when searched but can find a string with slashes in it. It is like it is a special character but not really https://confluence.atlassian.com/jirasoftwareserver085/search-syntax-for-text-fields-981156853.html
Vote on the issue above and hope that Atlassian fixes it.
while I totally agree that this should be possible in "native" JQL, if you need an immediate solution, this works out of the box in the app that my team is working on, JXL for Jira.
JXL is a full-fledged spreadsheet/table view for your issues that allows viewing and inline-editing all your issue fields. It also comes with Excel/Google Sheets-like column filtering capabilities. As these column filters use a different technology, searching for special characters works just fine.
This is how it looks in action for the summary column (it works the same way for any other text field):
(Note: I see that you're on Jira Server; while JXL isn't listed on the Marketplace for Server (only Cloud and DC), it still works perfectly fine, it's just that we need to generate a license for you. Just let me know if you're interested and I can send it over.)