nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to report on Epics,Stories and their Test

Shivika Shah

Hi,

I want to create a report for all the epics and their related stories and tests of those stories on Jira Server.

Can you please help me? I see there are lot of limitations as this is Jira server.

I do have Scriptrunner installed in the system but I am new to it.

Can I write JQL advanced query to achieve this result? Is it possible without any add-ons?

Any help is appreciated.

Thanks,

Shivika

Accepted answers

All comments

Alex_dddmmh

Hi @Shivika Shah

How do you relate stories to tests?

What format do you expect to extract the report from? Would a list of issues meet the requirements?

Please share a little bit more about your scenario.

Cheers,

Alex

Shivika Shah

Hi Alex,

Tests are added as test coverage under stories.

Stories are added under ‘issues in Epics’.

I want to show it on dashboard. Not sure if any gadget would allow that.

Not sure if I can create chart in excel.

I think list would suffice.

Regards,

Shivika

Alexander Bondarev_x6gjf3

Hi, @Shivika Shah

You can try some queries with issuesInEpics:

issueFunction in issuesInEpics("project = SSPB and status = 'To Do'") or project = SSPB and issuetype in (Epic) and status = 'To Do'

Alex_dddmmh

Hi @Shivika Shah

Thanks for sharing more details. I guess @Alexander Bondarev gave you an excellent path for Stories and depending on how you link stories to tests, perhaps you could also take a look at linkedissuesof function.

Cheers,

Alex

Dmitry Astapkovich _Colined_

If you will be ok to use 3rd party, Pivot Repot that we develop may help you quite a lot:

More demos are available here. Feel free to contact me if you need a demo or have any related questions.

Shivika Shah

Hi @Dmitry Astapkovich _Colined_ Thanks for the option. Unfortunately my organisation does not want to spend on add-ons.

Regards,

Shivika

Shivika Shah

Hi Alexander,

Thanks for your response. I am getting all issue types including Stories, test , bugs etc.

I tried to tweak the query with only issuetype in (Story, Test) but its not fetching all stories.

I will keep trying and If I get the desired result, I will update here.

I appreciate your help.

Regards,

Shivika

Shivika Shah

Hi Alex,

I have tried using the above mentioned query but I am not getting desired results. As I said earlier, I will update here if I get the required result.

Thanks for following up.

Regards,

Shivika

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-server

jira-software-server

report