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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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