Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,364,998
Community Members
 
Community Events
168
Community Groups

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

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.

2 answers

2 votes
Brant Schroeder Community Leader Aug 12, 2022

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

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

@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):

search-for-special-characters.gif

(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

Will let you know Hanes if I need it..

Suggest an answer

Log in or Sign up to answer