Searching for text that forms part of a word

[Adam Taylor]

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]

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

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