JQL for summary text search for quick filters

[Linnea Wallin]

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?

[Hannes Obweger - JXL for Jira]

Hi @Linnea Wallin,

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

[Priyanka Agrawal]

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")