Jira Report to show all comments based on JQL to show all issues AND subtasks and in the Epic

[Stefan Mueller]

Hello,

how can I generate are Jira report that lists all comments of the task and sub-task within the same epic?

I followed JQL to show all issues AND subtasks in the Epic and Filter: Get issues by epic with their subtasks? to create the proper filter but even get that to work. I don't have any apps like ScripRunner etc. and won't have in the near feature.

Afterward, I would like to create a report to show me the description, assignee, and comments on each task/sub-task.

How can I do that?

thank you

Stefan

[Petter Gonçalves]

Hello Stefan,

Unfortunately, JIRA JQL feature does not have parameters to return the sub-task issues from Stories under a specified Epic in a single query without specifying the parent of the Sub-tasks. You would only be able to achieve this using a plugin, however, here's the closest functionality you can achieve using only JIRA:

Create the following filter to return all the stories under a specific Epic:

"Epic Link" = ABC-123

Let's suppose the query below returned the Stories:

- CDE-456

- FGH-789

Once you got all the issues returned by this Epic, you can add each of them in the query below to return all the Sub-tasks of the Stories under the Epic together:

"Epic Link" = ABC-123 or parent in ("CDE-456","FGH-789")

Let me know if this information helps.

[Stefan Mueller]

it's a pity.

What plug-ins would allow me do this (the cheaper the better)?

[Petter Gonçalves]

Hello Stefan,

Check the tags you added in the question, it seems you are using JIRA Server. Is that correct?

There's a free add-on called AM Utils that was mentioned in one of the questions you were searching.

This free add-on provides you with a new JQL extension called issuesSubtasks that you can use to return the information you need with the query below:

"Epic Link" = ABC-123 or issuesSubtasks("Epic Link" = ABC-123)

This solution would have no costs for you. Can you try it and let us know how it goes?

For more information about this function, you can check the add-on documentation below:

Using AM Utils JQL Functions - issuesSubtasks

[Stefan Müller]

@Petter Gonçalves thank you for the quick response. We run the Data Center version but I emailed the vendor what they about running it on Data Center as it offers some more complex functions.
Moreover, the admin is currently on sick leave and won't return before two weeks time, so more time for research :), besides AM Utils, what else could do the job?

Once I got the sub-tasks filtered, could I publish their comments easily in reports?

thx Stefan  

[Petter Gonçalves]

Hey Stefan,

There are two other Plugins I have used before that can give you the same functionality, however, the price is the same or higher than Scriptrunner plugin. Here they are:

- JQL Search Extensions for JIRA

- JQL Tricks for JIRA

Unfortunately, I was not able to find any other free solutions to extend JQL functionalities that would achieve your need, so if you decide to not use AM Utils plugin, I recommend you to use Scriptrunner since it has the same price as JQL Search Extensions plugin and provide you with many other customization options using groovy scripts.

[Arkadiusz Głowacki]

@Petter Gonçalves not sure how you checked the pricing of both addons but JQL Search Extensions are 2~4 times (depending on the number of users on the instance) cheaper than script runner. For unlimited users, it is 6000$ for JQL Search Extensions and 25,000$ for the script runner.

[Stefan Mueller]

@Arkadiusz Głowackiand @Petter Gonçalves thank you for the feedback, so JQL Search Extensions for JIRA and JQL Tricks for JIRA would be the cheaper alternative to ScriptRunner for Jira, wouldn't it? Of course, overall functionality is less.

By the way, is there any example of a report showing Epic, Task and Subtask plus their written content (description, comments) and maybe the attachments attached?

[Arkadiusz Głowacki]

JQL Search Extensions and JQL Tricks for Jira will help you search for epics with all their hierarchy (stories and subtasks) but to be honest I'm not aware of any ready to use report that will present all the comments and/or attachments in the single place. It is hard for me to imagine how this should look like, because as I understand, showing the epic with stories and subtasks in issue navigator will not be sufficient?

[Stefan Müller]

I tried to visualize it. I would like to have a report like the one below, which could be distributed easily in sense of easily readable.

[Josef Plössnig]

Hi Stefan,

since your request is a long time ago, did you find a solution for your requirement. If so please share it. I need the same report as well.

THX in advance

[Stefan Mueller]

sorry unfortunately not.

The only solution I could think of is to use https://marketplace.atlassian.com/apps/1213821/eclipse-birt-for-sql-jql?hosting=datacenter&tab=overview as it is free :) and very powerful and fully customizable but some efforts are needed to get it operational.

Due to lack of resources, the project was not continued