nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL query to fetch issuetype story, task, bug for one project from list of projects based on labels

Sadhana Viswanathan

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!!

Accepted answers

Trudy P Claspill

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