Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Francisco August 23, 2019 edited

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 • 2 people like this

Suggest an answer

Log in or Sign up to answer