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 based on group

Javid Huseynli

Hi,

I have this JQL

(assignee in membersOf(DevOpsCoE) OR reporter in membersOf(DevOpsCoE)) AND project not in (DevOps)

It shows all issues where the assignee and reporter is a member of group "DevOpsCoE" excluding issues from project DevOps

I have a project with key DIT with issue types: Epic, Task, Story, Bug and DevOps Task.

Now I need to add to my JQL only issue type "DevOps Task"

Which JQL will be correct?

Accepted answers

Jack Brickey

will the following work?

type "DevOps Task" And ((assignee in membersOf(DevOpsCoE) OR reporter in membersOf(DevOpsCoE)) AND project not in (DevOps))

Pier-Olivier Tremblay_rvqy2m

Do you need only the DevOps task issue type?

Jack's answer is good but if you need to filter "DevOps task" issue type only when the issue is in DIT and get all the other issue types from other project it won't do it.

Let us know the exact outcome you are looking for so we can advise better.

PO Tremblay

FMX Solutions - Gold solution partner

All comments

Jack Brickey

will the following work?

type "DevOps Task" And ((assignee in membersOf(DevOpsCoE) OR reporter in membersOf(DevOpsCoE)) AND project not in (DevOps))

Pier-Olivier Tremblay_rvqy2m

Do you need only the DevOps task issue type?

Jack's answer is good but if you need to filter "DevOps task" issue type only when the issue is in DIT and get all the other issue types from other project it won't do it.

Let us know the exact outcome you are looking for so we can advise better.

PO Tremblay

FMX Solutions - Gold solution partner

Javid Huseynli

From DIT project I need only issue type DevOps task and all other issues from other projects where assignee and reporter is a member of group DevOpsCoE except DevOps project

Javid Huseynli

No, it shows only DevOps task from DIT project. From DIT project I need only issue type DevOps task and all other issues from other projects where assignee and reporter is a member of group DevOpsCoE except DevOps project

Pier-Olivier Tremblay_rvqy2m

(project in (DIT) AND type = "DevOps task") OR (project not in (DIT,DevOps) AND (assignee in membersOf(DevOpsCoE) OR reporter in membersOf(DevOpsCoE)))

Translation : All the issues of type DevOps task in project DIT OR All issues not in DIT AND DevOps where the assignee OR the reporter are in DevOpsCoe.

Does it do the trick?

Jack Brickey

(Project = DIT AND type = devops) OR (project != DIT And (assignee in membersOf(DevOpsCoE) OR reporter in membersOf(DevOpsCoE)))

here is how it breaks down according to your recent response...

From DIT project I need only issue type DevOps task >> Project = DIT AND type = devops
all other issues from other projects where assignee and reporter is a member of group DevOpsCoE except DevOps project >> (project != DIT And (assignee in membersOf(DevOpsCoE) OR reporter in membersOf(DevOpsCoE)))

Please note the OR in bold. Your statements are a bit conflicting in one case you seem to want both the assignee and reporter to be a member of the DevOpsCoE however your JQL uses OR. If you need both in the group change OR to AND.

if this isn't what you're looking for please articulate and words precisely what you want.

Javid Huseynli

It works. Thank you!

Javid Huseynli

It does. Thank you!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-service-management

jira-service-management-server