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,370,158
Community Members
 
Community Events
168
Community Groups

Writing complex JQL - fetching all issues that have child issues in another project

Context: We have a project that only houses custom Issue type "Initiative" which is parent of Epic Issue type. The hierarchical issue organization example is:

  • Initiative(belongs in JIRA Project A) - issue Key INIT-1
    • Epic1 (belongs in Project B) - issue Key CAT-1
    • Epic2 (belongs in Project B) - issue Key CAT-2
    • Epic3 (belongs in ProjectC) - issue Key DOG-1
    • Epic4 (belongs in project B) - issue Key CAT-3

I would like to know if there is a way to write a query which will bring up all initiatives from project A which has child issues in project B.

Is there a way to do this?

2 answers

@harshita.sharan

if you have advanced roadmaps, then you can use the Parent Link field, as suggested by @Mathias Richter

Also, if you have scriptrunner then use what he had suggested; if you don't, then use this: "Parent Link" = INIT-1

0 votes

Hi @harshita.sharan ,

assuming you're using the Parent Link field provided by Advanced Roadmaps, the following JQL function should do the magic:

https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/portfolio

The following JQL should show all the 4 mentioned Epics:

issueFunction in portfolioChildrenOf("key = INIT-1")

In case you use ScriptRunner.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS

Atlassian Community Events