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_mqshfv

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