Can you search on a sub string in JIRA?

Question

Hi,

I am trying to search for a sub string within a label.

eg I have a set of labels that are:
Step_1
Step_2
Step_3
Etc

I can do a search that says:
Labels in (Step_1, Step_2, Step_3 etc) but this is quite cumbersome as the number of steps increases.

A better solution would be if I could search for the string "Step" within the string that represents the label.  An example for those that know vba would be the instr() function.

I have tried the fuzzy search but this is not supported by the labels field.
I have tried the wildcard "*" but this does not appear to be supported either.

I then tried components, that does not support the fuzzy search either, ironically if I use = and a wildcard "*" it advises me to use the fuzzy search that it does not support!

For reference it is a server based instance of JIRA I am using and not a cloud based one.

Help!

Hannes Obweger - JXL for Jira · Answer

Hi @Mark Irvine

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, you may want to have a look at 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 (available for all fields, including labels) 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 filter based on 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

Ashish Bijlwan_zogaqs · Answer

Hi @Mark Irvine

Welcome to the Atlassian Community!

You can use below

issueFunction in issueFieldMatch (subquery, fieldname, regexp)

for more details, please refer: https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/match-functions

Thank you,
Ashish