In JQL, how to: "UNION" (i.e. pr = 1 AND status=done UNION pr =1 status=closed)

Francisco August 23, 2019

In JQL, how do I do something like this search:

  • pr = 1 AND status=done
  • UNION
  • pr =1 status=closed

1 answer

1 vote
DPKJ
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 23, 2019

You have two ways to accomplish this,

  1. (pr = 1 AND status = done) OR (pr = 1 AND status = closed)
  2. pr = 1 AND status in (done, closed)

    So to union we can either use `OR` or we can use `in`.

Radek Bartoň
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 14, 2021

But that does not keep the order of UNION.

Like # people like this

Suggest an answer

Log in or Sign up to answer