in a report generated using a query, is it possible to display columns about the subtasks or parent?

ribas March 27, 2024

our JIRA process is made with ticket which type is "Change Request". each Change Request ticket has subtask that are ticket which type is called "impact".

 

is it possible to make a query about "Change request" and display columns that are fed with attributes of "impact" that are subtasks of the "Change request" ?

 

same question about a query that will list "impact" and where we would like to display columns that are fed with attributes of the "Change Request" that is parent of the impact ?

2 answers

1 vote
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 27, 2024

Hello @ribas 

That is not possible with the native functionality of Jira Data Center.

Are you willing to consider acquiring a third party plugin to achieve your requirement?

ribas March 28, 2024

maybe :) maybe also we already have such a plugin but we don't know all possibities offered by plugins we have.

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 27, 2024

Hi @ribas

I'm not personally aware of such a report. However, if you're open to solutions from the Atlassian Marketplace, there are a number of hierarchy-focused apps that may get you pretty close.

E.g., my team and I work on an app named JXL for Jira in which you could easily show your change requests together with the respective "impact" tickets, like so:

change-sub-task-report.gif

For context, JXL is a full-fledged spreadsheet/table view for your issues 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 advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

With these, you can build a view/report like the above in just a couple of clicks.

Any questions just let me know,

Best,

Hannes

ribas March 28, 2024

thanks for your answer. for instance we have BigPicture ou easyBI plugin. do you know if these pluggin could do this ?

Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 28, 2024

Unfortunately I don't know - sorry! You may want to have a look at their respective documentations.

Roberts Čāčus
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 28, 2024

Hi @ribas

You can create a report and display parent and sub-task issues with the Issue dimension in eazyBI. Please see a simple example below:

SCR-20240328-nkhh.png

You can add issue properties to display each issue details, and add some metrics. Metrics or measures will sum up to the parent of the sub-task.

Please visit the eazyBI documentation page for more details on creating reports - https://docs.eazybi.com/eazybi/analyze-and-visualize/best-practices-for-report-creation.

You can also visit the eazyBI Demo account to see some of the other features - https://eazybi.com/accounts/1000/dashboards/4553-jira-issues.

Best,
Roberts // support@eazybi.com

ribas March 28, 2024

thanks a lot I will look at it to make it working !

Suggest an answer

Log in or Sign up to answer