Search for Hashtag in the Description Field during Automation

[Carlos Rodrigues]

I've created an automation based on the body of the email sent by the users. The automation looks for specific hashtags (ie: #computer, #ERP, etc). 

The problem is that when I do the search on the description (ie: description ~ "#ERP"), it returns all tickets that have the work ERP, not the ones with a hashtag only. 

How should this JQL be created?

[Morgan Folsom]

Hi Carlos, 

According to Atlassian's documentation it looks like while you can search for reserved characters (# being one of them) by entering \\, the search essentially ignores the character itself. 

Some resources & excerpts below:

Advanced Searching - Restricted Characters

• "if you are searching a text field and the character is on the list of special characters in text searches, precede them with two backslashes. This will let you run the query that contains a reserved character, but the character itself will be ignored in your query. For more info, see Special characters in Search syntax for text fields."

Search Syntax for text fields - special characters

• "Special characters aren’t stored in the index, which means you can’t search for them. The index only keeps text and numbers, so searching for “\\[JIRA Software\\]” and “JIRA Software” will have the same effect — escaped special characters ([]) will be ignored in the search. "