nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL for summary text search for quick filters

unknown

Hi!

Trying to figure out what goes wrong when I'm trying to create quick filters for a text in summary search. The words I want to filter out is LAM and HTTP, and the summaries can look like this(More text before and after):

X2SPNCPP1/LAM

VMAXAGWP01/HTTP

The combinations of letters are different in a lot of the issues. The jql I am trying to use are these different combinations:

summary ~ ''http'' OR summary ~ ''lam''

summary ~ ''HTTP'' OR summary ~ ''LAM''

summary ~ ''http*'' OR summary ~ ''lam*''

summary ~ ''HTTP*'' OR summary ~ ''LAM*''

summary ~ ''/http'' OR summary ~ ''/lam''

But I still do not get a single ticket when I add the filters.

Any suggestions what to do here?

Accepted answers

Priyanka Agrawal_nef1a1

Well, with JQL the mentioned queries don't provide any result atleast to me.
But when I tried Scriptrunner Enhanced search it seems to work.

Here's the query I tried:

issueFunction in issueFieldMatch("Project = ABC", "summary", "http")

All comments

Priyanka Agrawal_nef1a1

Well, with JQL the mentioned queries don't provide any result atleast to me.
But when I tried Scriptrunner Enhanced search it seems to work.

Here's the query I tried:

issueFunction in issueFieldMatch("Project = ABC", "summary", "http")

Hannes Obweger - JXL for Jira

Hi @[deleted],

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.

This being said, if you're open to solutions from the Atlassian Marketplace, you'll find a number of 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

John Funk

Marking Priyanka's answer as Accepted. Let us know if you still need assistance.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-cloud