jql intersection

Some Guy_rd4sji

Hi,

 

I wanted to do a simple INTERSECT with JQL but a standard query will always perform a UNION. The keyword intersect does not work. It's quite an overhead (query and performance) to include/exclude filters and make proper intersection queries.

ATM I am doing it so

((filter = A AND filter = B AND filter = C) OR (filter = A AND filter =  OR (filter = A AND filter = C) OR (filter = B AND filter = C))

 

Is there any way to make this more performant and readable?

 

Thank you

Nic Brough -Adaptavist-

JQL is not SQL, and the operators are focussed on helping non-programmers find the issues they are looking for.  It's aimed more at natural language use.  There is no "intersect", it's not needed.  Nor is there a Union for that matter, again, it's not needed.

Start by asking the question in natural language, you can more easily translate that into JQL than you can by trying to work out how to replicate union or intersect from SQL.

I'm looking for issues that are in projects A, B or C, and all have a label of Red or Amber, for example.

Also look at the reason behind the question.  Are you really looking for issues that appear in two or more filters?  How is that useful?  What does it tell your users?

(I can think of a couple of uses for it, but they all lead back to "people not understanding what they're doing or having mutiple ownership of issues", both of which are things you should be fixing, not filtering for)