Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Usage of multiple verbose filters

Some Guy
Contributor
August 19, 2024

Hi,

 

I created multiple (verbose) filters which give me a set of issues. For example

Filter "A"

issueType NOT IN (Defect, Test)

and filter "B"

createdDate >= "2024-01-01"

 

In the next step, I want to use that two filters in other queries like this

"Epic Link" = MyEpic AND filter IN (A,B)


This output is a full outer join with all the issues from filter A and filter B but I need a inner join, which works with

"Epic Link" = MyEpic AND filter IN (A) AND filter IN (B)


Is there a way to make the query as short (and readable) as possible with a inner join?

 

Thanks.

2 answers

1 accepted

0 votes
Answer accepted
Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 19, 2024

Hello @Some Guy 

What you have is as best you can get.

  • Filter = A OR Filter = B
  • Filter = A AND Filter = B

 

You cannot get more succinct than that.

0 votes
Benito Jiménez _Sevidev_
Community Champion
August 19, 2024

In my opinion, to increase visibility, I would include all clauses in the same filter, separating searches with line breaks:

"Epic Link" = MyEpic AND
issueType NOT IN (Defect, Test) AND
createdDate >= "2024-01-01"

jql filter.png

Obviously, the filter is longer, but at a glance, the user can understand the filter's clauses.

 

Hope this help you!

Kind regards.

 

Some Guy
Contributor
August 20, 2024

I think we use the server version, unfortunately I cannot use multiple lines to separate it.

Benito Jiménez _Sevidev_
Community Champion
August 20, 2024

Hi @Some Guy , you can start a new line from Jira JLQ search with Shift + Intro. Other Alternative is to build the query in an external text editor and copy/paste in Jira.

Like Some Guy likes this

Suggest an answer

Log in or Sign up to answer