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?

[Jack Brickey · Accepted solution]

will the following work?

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

[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

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

[Pier-Olivier Tremblay · Accepted solution]

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

[Pier-Olivier Tremblay]

(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?

[Javid Huseynli]

It does. Thank you!