Hi all,
I'm using this JQL query to fetch stories, bugs & tasks for a list of projects:
issuetype in (story, Bug, Task) AND project in ("Project1", "Project2", "Project3", "Project4") AND status in (done, DONE) AND resolved >= startOfDay(-730) ORDER BY resolved Desc
but I want to fetch only those stories, bugs & tasks for Project3 that has labels "label1" & "label2"
I know I can independently fetch it by using:
issuetype in (story, Bug, Task) AND project = "Project3" AND labels in (labe1, label2) AND status in (done, DONE) AND resolved >= startOfDay(-730) ORDER BY resolved Desc
How can I merge these two queries into one?
Thank you in advance!!
Hello @Sadhana Viswanathan
Welcome to the Atlassian community.
Try this:
issuetype in (story, Bug, Task) AND (project in ("Project1", "Project2", "Project4") or (project = "Project3" AND labels in (labe1, label2))) AND status in (done, DONE) AND resolved >= startOfDay(-730) ORDER BY resolved Desc
Thank you, Trudy!! worked for me :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Sadhana Viswanathan ,
Using Colored Label Manager you can visualize your labels with at-a-glance quickness to save time and avoid mistake - Make your issues more colorful
Allow your team to define their labels, cleanup and organize them quickly with bulk powerful functionality .
Karim
Atlassway Team
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.