Is there a query to show sign off status for subtasks along with the status of the parent issue?

[tbundy]

I am looking for help on creating a report for a specific subtask, "preview" subtasks, and the sign off status along with the status of the parent issue. 

I would like to see the preview subtasks that show "launched signed off" along with the parent issue status being in "Hold" or "Canceled" 

Is there any JQL query that would show me columns with both statuses in Filters?

[Marlene Kegel - codefortynine]

Hi @tbundy,

I am Marlene from codefortynine.

Our Jira cloud app Dynamic Custom Fields for Jira could help you with your use case.

With our app you can calculate custom field values dynamically using Jira Expressions. We actually offer a template to display the status of the parent issue within the issue. So you don't have to know Jira Expression Language in order to add this field to your issues. 

If you add the "Parent Status" custom field to your subtask issue type, it would be displayed as a field in the issue and can be used in JQL.

The process of adding the field is pretty easy. After installation of Dynamic Custom Fields for Jira, simply

• Navigate to the Field Configuration of the Dynamic Custom Fields
• Select "Parent Status" as a template under "Create new field"
• Save the new custom field
• Add the "Parent Status" custom field to your issues as any other custom field

You can find a list of all templates in our documentation.

[Hannes Obweger - JXL for Jira]

Hi @tbundy

the biggest (only?) challenge with this will be to also show the parent status (if it wasn't for this, you could probably just use Jira's Advanced Issue Search). To the best of my knowledge, you'll need extra tooling for this.

One option would be to use Jira Automation to "propagate" the parent status down to its children, and then view the respective field on the children.

Alternatively, you should find a solution in the Atlassian Marketplace. I can only speak for the app that my team is working on - JXL for Jira - but here, your report would be easy to do.

JXL is a full-fledged spreadsheet/table view that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called "smart columns" that aren't natively available, including the parent status. This is how it looks in action:

As you can see above, you can easily view, sort, and filter by the parent status just like with any other field, and also use it across JXL's advanced features such as support for issue hierarchies, issue grouping, sum-ups, or conditional formatting. Once you've set up your issue list, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

As said above, there may be other apps that can 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.

Hope this helps,

Best,

Hannes

[Nic Brough -Adaptavist-]

How exactly are you recording the sign -off status for these issues?  Status?  System field?  Custom field?