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

Question

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.

neelam annad · Answer

Will let you know Hanes if I need it..

Hannes Obweger - JXL for Jira · Answer

@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 · Answer

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