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; } } }

FILTERS: all issues with parents JIRA CLOUD

Irina Pozdnyakova_tbsk5y

Hey!

I have 2 main projects: X, Y

Also I have 3 projects: A, B, C

And I have a group of users: Group

So I can create a ticket in X/Y project and Escalate it to HR for example. When escalating, a child ticket is automatically created in the A project. The same for B and C projects.

I need to create a filter

1. that gonna show me all tickets in A, B, C projects created by members of a group and they have a parent task in X, Y projects

Tried something like project in (A, B, C) and reporter in memberOf("group") AND don't know how to deal with parent\child

2. that gonna show me all tickets in A, B, C projects that are not childs of any tickets in X, Y

Tried several functions but not working for me.

Thanks in advance!!

Accepted answers

Irina Pozdnyakova_tbsk5y

Found a solution, for all who stuck!

using ScriptRunner Enhanced Search

issueFunction in linkedIssuesOf("project = A OR project = B", "is parent of") AND reporter in membersOf("group")

You cant change "is parent of" to "is child of" or add issue type if u need or maybe add linking type "is block of" "is epic of"

All comments

MW_ivmw1m

I think that it's hard to achieve using native functionalities.

Maybe you can try to create a new type of linking issues (let's call it "Escalates to" and "Is escalated by")

and then you can easily run a SQL like

Project IN (A, B, C) and issueLinkType = "Is escalated by" AND reporter in membersOf("group-name")

The second question also becomes easy if you use this method:

Project IN (A, B, C) and (issueLinkType IS Empty or issueLinkType != "Is escalated by")

Irina Pozdnyakova_tbsk5y

Hey, MW, thanks you kindly for your advice but unfortunately I can't change anything inside project since it's already finished. So I need to deal with "customer wishes" using native functionalities.

I tried to create some filters using ScriptRunner but didn't work with these functions and kinda stuck

Irina Pozdnyakova_tbsk5y

Find the solution, but there is another problem, how to get the same jql with several projects?

I need to add also B and C project (tried to use AND operator also project in but didn't work for me)

issueFunction in linkedIssuesOf("project=A")

Irina Pozdnyakova_tbsk5y

Found a solution, for all who stuck!

using ScriptRunner Enhanced Search

issueFunction in linkedIssuesOf("project = A OR project = B", "is parent of") AND reporter in membersOf("group")

You cant change "is parent of" to "is child of" or add issue type if u need or maybe add linking type "is block of" "is epic of"

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-cloud

jql

hierarchy

issue-link

jira-service-management-cloud

jira-service-management