JQL for 2 projects

[Nodar Vardiashvili]

Hi I have 2 projects : "A" and "B"

In "A" I have initiative Issue type and in this initiative I have a 10 epic from project B.

and this epics have tasks and stories from project "B".

I want to create filter where I can see epics from project "B" (Parent Link for this epics is PROD-166).

I want to see all epics which parent link is a PROD-166(project "A") and all stores and tasks(project B) which is in this epic(project B).

[mauricio.groth]

Hi @Nodar Vardiashvili 

I’m Maurício, a support engineer at Appfire and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your children’s issues from PROD-166

issue in childrenOfIssuesInQueryRecursive("key = 'PROD-166'")

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!
Best regards,
Maurício

[Hannes Obweger - JXL for Jira]

Hi @Nodar Vardiashvili

this is a tricky one, since you want to retrieve issues "across" hierarchy levels, which isn't well supported in JQL. To the best of my knowledge, you'll need extra tooling for that.

• If you have Advanced Roadmaps, you should be able to create a plan that contains a.) your initiative (PROD-166), and b.) any potential child and grandchild issues from project B. AR should now show all the children below PROD-166, and all other issues in an "Other issues" bucket that you can simply ignore.
• There's different apps from the Atlassian Marketplace that can help with that. First, there's a number of apps that extend JQL by additional functions, including hierarchy-related functions. I've used JQL Search Extensions a few times and it works great.
• Alternatively, you could try one of the more hierarchy-focused apps from the Marketplace. These apps typically have their own ways of figuring out parent/child relationships between issues, and provide more powerful ways to define and navigate through issue hierarchies. I myself work on such an app, in which your use case would be easy to solve; I'll provide more details below.

Hope this helps,

Best,

Hannes

[Nodar Vardiashvili]

Hi,

yes, I am using advanced roadmap, I need to create filter  about child and grandchild and I need help to create this filter. 

[Hannes Obweger - JXL for Jira]

Just to expand on the last point, this is how this would look in the app that my team is working on, JXL for Jira; TLDR: You'd create a sheet with your relevant issues (much like you'd do in Advanced Roadmaps, see above), configure your issue hierarchy (that's just a couple of clicks) - and that's it:

Once you have your list of issues, you can work on these directly in JXL (much like you'd do in e.g. Excel or Google Sheets), trigger various operations in Jira, or export them for further processing.

As said above, there may be other apps that help with this, too. You may already know that you can trial any app for free for 1 month, and depending on the size of your size, it may be free forever. So if an app is an option for your, perhaps try a few and see which works best for you.

Any questions just let me know!

[Hannes Obweger - JXL for Jira]

@Nodar Vardiashvili

if you really want to create a filter, you'll need some JQL extension app. I don't know the exact syntax, but perhaps someone else can jump in.

Within Advanced Roadmaps, could you perhaps simply filter your view so that you can only see the one initiative?

Alternatively, you could try creating a new plan with 2 issue sources - one being a filter that *only* contains PROD-166, the other one being "Project B". That's essentially what I proposed in my original answer for Advanced Roadmaps.