Searching in text fields returns differnt results

Question

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 P Claspill · Answer

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

saravanan subramanian · Answer

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

Trudy P Claspill · Answer

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.