how to find completed increments that still have stores in an incomplete state

[Joseph Shaffer]

how to find completed increments that still have stores in an incomplete state

[Hannes Obweger - JXL for Jira]

Hi @Joseph Shaffer

welcome to the community!

Unfortunately, "plain" Jira isn't too great with searching across issue hierarchies, so to the best of my knowledge, you'll need extra tooling to solve your use case. A few directions forward:

• You may be able to propagate the information from the stories "up" to the increment using Jira Automation, and then use the respective field to search for your increments.
• There's different apps from the Atlassian Marketplace that can help with that. On the one hand, 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

Edit: I see that you've tagged for question for Jira Server. You may have heard that Server apps are no longer available via the Atlassian Marketplace. Are you planning to move to Data Center or Cloud in the foreseeable future? I'd strongly recommend that. If not, you may be able to arrange something with the respective app vendor.

[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; put simply, you can load your increments and incomplete stories into a sheet, enable the default issue hierarchy, and hide any increments without children. That should give you what you're looking for:

Once you've narrowed down 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.

In case you plan to stay on Jira Server: JXL is perfectly compatible; it's just that we need to generate a license for you. If the above looks interesting, just let me know and I'll happily start a free trial for you.

Best,

Hannes