Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,297,157
Community Members
 
Community Events
165
Community Groups

FILTERS: all issues with parents JIRA CLOUD

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

3 answers

1 accepted

2 votes
Answer accepted

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"

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")

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")

 

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 :)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Posted in Jira Service Management

Jira Service Management Documentation Opportunities

Hello everyone, Hope everyone is safe! A few months ago we posted an article sharing all the new articles and documentation that we, the AMER Jira Service Management team created. As mentioned ...

340 views 0 10
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you