JQL for 2 projects

Question

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 · Answer

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 · Answer

@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.

Hannes Obweger - JXL for Jira · Answer

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!