Searching in text fields returns differnt results

[saravanan subramanian]

We have a field which may contains values like this - app-903-dmz-default .  We want to filter the items where the field has dmz text in it.

Jira cloud is not returning any thing if we search like Field~"dmz*" or Field~"dmz" . It returns unexpected values with Field~"-dmz*".

What will be exact JQL syntax to get items with dmz in that field.

[Trudy Claspill]

Hello @saravanan subramanian 

Text searches do not support searching for portions of words.

You can find more information in this documentation:

Search for work items using the text field - Word Stemming 

[Trudy Claspill]

There might be a third party app that extends JQL capabilities to support partial word text searches. Are you willing to consider an app?

Is this a one time need or an ongoing need?

What do you want to do with the search results? Do you need to feed them into a dashboard or agile board? Or do you just need to get the list of issues and provide it to somebody? If you don't need to feed the results into another feature, it might be possible to get the data using Automation Rules.

[saravanan subramanian]

We need it for a JQL used it in our automation!

[Trudy Claspill]

Can you share with us a screen image of your entire rule and point out where you are trying to use the JQL? We may be able to suggest an alternate implementation to accomplish the same thing