Want to search the character “/“ in business sponsor field

[neelam annad]

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 “/“

please advice.

[Brant Schroeder]

@neelam annad I have had this issue before and it looks like you are suffering from this https://jira.atlassian.com/browse/JRASERVER-61754 

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.  

[neelam annad]

Very sorry to hear that there is no solution to search “/“

[Hannes Obweger - JXL for Jira]

@neelam annad

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.)

Best,

Hannes

[neelam annad]

Will let you know Hanes if I need it..