The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

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

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

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

1 vote
DPKJ
Community Champion
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
TAGS
AUG Leaders

Atlassian Community Events