Creating a custom JQL-Filter

Question

Hello, I would like to create a JQL filter like that:

Summary contains any of the following (word1,word2,word3, ...) -> So if the summary contains at least 1 of these words, the ticket should show up in the results.

In addition I will use Fields like Project and custom fields like author and URL, but I need a solution for adding up to 150 different topics/words.

Can someone help me out? :)

Petter Gonçalves · Accepted Answer

Hello Theresa,

Welcome to Atlassian community!

I understanding that you would like to configure a filter that will return issues which summary contains more than 150 specific words. Is that correct?

The functionality to search the summary of the issue with JQL is pretty simple:

summary ~ "word1" or summary ~ "word2"

Also, you can use the * icon to search for a wild-card match for a word:

summary ~ "word*"

The problem here is the number of words you want to specify since the character limit of the JQL bar is 2000.

I believe the query would become much longer and could cause you some performance issues if you describe 150 different words to be searched, however, it is possible to accomplish by creating multiple filters than reference them in a single filter:

filter = createdfilter1 and filter = createdfilter2

For more information about the operators used above, check this documentation:

- Advanced searching - operators reference

Let us know if this information helps.

Andrei Pisklenov _Actonic_ · Accepted Answer

HI @Theresa Paape

One of the easiest way to search by word parts or combinations etc. is to use regex expressions. You can try the add-on Power JQL.
And the request like:

issue in powerIssue("project=DEMO", "summary, description", "(?i).*(word1|word2).*")