Community
Q&A
Jira
Questions
How to report on Epics,Stories and their Test

How to report on Epics,Stories and their Test

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

3 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

Regards,

Shivika

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Dmitry Astapkovich _Colined_ likes this

0 votes

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'

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Was this helpful?

Thanks!

Jira

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

How to report on Epics,Stories and their Test

3 answers

Comments for this post are closed

Comments for this post are closed

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events