Can't search for by parts of words in custom fields

Gerencia PS

How do I search for parts of words in a determined custom field?

Example: i need to search for all the issues that contain "RMC" (like ACRMC and XYZ-RMC). In this case, the advanced search would be: "Custom Field" ~ "RMC", but no issues are showed.

When I change the criteria ("CustomField" ~ "-RMC"), it works for all the fields that start with RMC after the hyphen (it also shows the issues that contain "-RMD" even if the indexing language is in "Other").

How can I search for the issues that contain "RMC" in the middle of the word?

Zachary Miller_v2ml32

Hi @Gerencia PS 

With out of the box JQL we can sorta accomplish what you need here. In JQL you can use the CONTAINS operator "*" to specify a partial string.

• IE
• summary ~ "He*"
• An issue would the summary "Hello World" would appear in the search

The limitation with this however is that this cannot search for string within a word

• IE
• summary ~ "ell*"
• An issue with the summary "Hello World" would NOT appear in the search

If this limitation doesn't fit your current workflow I would recommend 

https://marketplace.atlassian.com/apps/1216891/power-jql-extended-search-functions?hosting=server&tab=overview&_ga=2.46741029.369570024.1558354594-387361959.1527881499

This appears to have the necessary functionality to allow you to search within strings in JQL