How can I find if certain letters are in a word?

[salih_benice]

hello,

How can I find if certain letters are in a word? for JQL.

thanks.

[salih_benice]

hello @Trudy Claspill 

sure,  if certain letters appear in a word.

for example, I want it to find if it contains f01

ZZ34GDSEEXX3510VDFf01.domain.local

thanks.

note: I used many commands in the link. but without success
Use advanced search with Jira Query Language (JQL) | Jira Service Management Cloud | Atlassian Support

[Trudy Claspill]

Hello @salih_benice 

Welcome to the Atlassian community.

Can you provide a more detailed example of your use case?

[Trudy Claspill]

Hello @salih_benice 

Thank you for that additional information.

I don't believe that can be done with JQL. There may be an alternative solution using Automation Rules.

What would you want to do with the results once you had them?

Would all the issues be within one project, or in multiple projects?

[Hannes Obweger - JXL for Jira]

Hi @salih_benice

welcome to the community!

To the best of my knowledge, JQL's wildcard matching doesn't work for strings that occur within longer sequences of characters. I believe that this is because of how Jira does its internal indexing for full text JQL searches.

This being said, if you're open to solutions from the Atlassian Marketplace, you'll find several apps that either extend JQL by additional functions, or provide their own, more powerful search mechanisms.

E.g., your use case would be trivial to solve using the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. One of the filtering options that is available for all fields is text filtering, which performs a partial match by default.

This is how it looks in action:

For more advanced use cases, you can also use logical operators (AND, OR, NOT) as well as regular expressions.

I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes