The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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
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.
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.
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.
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.
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.
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.
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.
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.
👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.