Need a help on JQL

[Manikandan Kaliyaperumal]

I need to filter initiatives based on the epic status (Linked to Initiative). Please let me know how can we implement them using JQL ?

[mauricio.groth]

Hi @Manikandan Kaliyaperumal 

I’m Maurício, a support engineer at Digital Toucan 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 initiatives whose epic is open.

issue in parentsOfIssuesInQuery("type=Epic and status = open")

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 @Manikandan Kaliyaperumal

if I understand you correctly, you want to retrieve all initiatives that have at least one epic (or all epics?) that is in a particular status - is that correct?

If that's the case, you essentially need to perform a "cross-hierarchy-level" search, which unfortunately isn't very well supported in "plain" Jira/JQL; you'll need extra tooling for that. A few directions forward:

• I haven't tried this myself, but you may be able to use Jira Automation to "propagate" the information up to the parent, and then filter your initiatives based on the respective field.
• 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 - if I understood it correctly - would be easy to solve; I'll provide more details below.

Hope this helps,

Best,

Hannes

[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, configure and enable your issue hierarchy, and then use JXL's various filtering capabilities to narrow down your list of issues:

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!

[Rahul_RVS]

Hi @Manikandan Kaliyaperumal 

If you are fine with a mktplace app to get this data, you can try out our add-on.

Issue Hierarchy Reports 

The app will show your hierarchy based on Issue Links and also let your filter on the child issue using JQL.

Disclaimer : I work for the vendor who built this app

[Rilwan Ahmed]

Hi @Manikandan Kaliyaperumal ,

Can you please explain briefly what actually is required. Some examples will help us. 

Meantime as an example: 

• Find issues that belong to epic "Jupiter", where "Jupiter has the issue key ANERDS-31:
  "epic link" = ANERDS-31 
or
"epic link" = Jupiter

Refer this link for Epic link related syntax