Searching for text that forms part of a word

Question

Hi!

I want to search for Issues where someone has added an order number to the text in title or description etc.

All our order numbers start with "RITM" - for example "RITM1234567".

However when I try searching using the following JQL:

Text ~ RITM

The search only returns Issues where the standalone work 'RITM' exists, not where the letters 'RITM' for part of a longer piece of text - e.g. RITM1234567

Is there an out of the box way to get Jira to return a search for Issues that contain the letters 'RITM' as part of a longer string of text?

Thanks!

Brant Schroeder · Answer

@Adam Taylor

The contains function is what you will need to use.  It will return what you want and most likely more.  https://support.atlassian.com/jira-service-management-cloud/docs/advanced-search-reference-jql-operators/

EXAMPLES

* Find all issues where the Summary contains the word "win" (or simple derivatives of that word, such as "wins"):

summary ~ win

* Find all issues where the Summary contains a wild-card match for the word "win":

summary ~ "win*"

* Find all issues where the Summary contains the word "issue" and the word "collector":

summary ~ "issue collector"

* Find all issues where the Summary contains the exact phrase "full screen" (see Search syntax for text fields for details on how to escape quote-marks and other special characters):

summary ~ "\"full screen\""

Bill Sheboy · Answer

Hi @Adam Taylor

Have you tried using wildcards with the CONTAINS operator, like this:

text ~ "RITM*"

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-CONTAINS-CONTAINS--

Kind regards,
Bill