Jira Cloud for Google Sheets doesn't import reports at epic level

[Harvinder kaur]

I want to import reports based on Epic name or Epic link in google sheets, but it doesn't work. Is there any way to work this?

[Hannes Obweger - JXL for Jira]

Hi @Harvinder kaur

I understand that you want to see your epics along with their respective stories, and get the data into Google Sheets.

If you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

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. If you want to see your issues in their default hierarchy (i.e., epic/base/sub-task), this can be done in just one click:

As you can see, this view is fully interactive, meaning that you can work on your issues directly in JXL (but also trigger various operations in Jira). Of course, you can also export your data to XSLX (i.e., Excel or Google Sheets) in just one click.

Any questions just let me know,

Best,

Hannes

[Iryna Komarnitska_SaaSJet_]

Hi @Harvinder kaur ,

Try this query. It will pull up all the tasks belonging to a particular epic for you

issuetype = sub-task OR "parentEpic" IN (Epic Key) AND project = "Project name" 

[Harvinder kaur]

Hi @Iryna Komarnitska_SaaSJet_ It only gives the epic ticket, I need all the task or bugs for a particular epic in project.

one project -> Multiple Epics -> Each epic has multiple jira items.

[Iryna Komarnitska_SaaSJet_]

@Harvinder kaur 

I tried this JQL and managed to pull epic+tasks that are linked to it.

Could you tell us more about what you need this request for? Do you need to analyze data by task further, or do you just need a report for external users?

[Harvinder kaur]

@Iryna Komarnitska_SaaSJet_  So my project has multiple epics like UI, Backend etc for different teams. Each Epic has multiple task for team members. I want to show the report in google sheet to external user like from UI epic how many items are done or in progress and who is working on. It is kind of progress report per epic.  I hope it's clear little bit now?

[Dave Rosenlund _Trundl_]

Hi, @Harvinder kaur. Welcome to the community.

Maybe you can be a bit more specific.

• Are you able to import anything at all? 
• Can you tell us about the JQL you are using (share some examples)?
• Are you using any filters?

The more info. you share, the more likely it is someone may be able to help you. :)

-dave

[Harvinder kaur]

Hi @Dave Rosenlund _Trundl_  I am able to import the project level reports. My project has multiple Epics and I want to have Epic level report.

My query is something like this

PROJECT = "ABC" AND ISSUETYPE IN ("Task", "Bug") AND STATUS IN ("Done", "In Progress", "To Do") and "Epic Link" = "https://velmeniai.atlassian.net/browse/epic" ORDER BY duedate ASC

[Dave Rosenlund _Trundl_]

Unfortunately, I don't have time this week to try and figure this out myself @Harvinder kaur but it seems that between you and @Iryna Komarnitska_SaaSJet_ you are getting close to the right answer.

And, as @Hannes Obweger - JXL for Jira points out, there are a number of solutions on the Atlassian Marketplace (JXL is one of them) that might make this a lot easier for you. If you are open to that approach I would look at JXL, Structure, and Hierarchy for Jira.

You may want to look at Better Excel Exporter for Jira.

All of the above will make things much easier for you. 

Good luck!

[Harvinder kaur]

Hi Dave, I am able to import the project level reports. My project has multiple Epics and I want to get the reports based on that. I tried with Epic name but it doesn't work.

something like this - 

PROJECT IN (ABC) AND ISSUETYPE IN ("Task", "Bug") AND STATUS IN ("Done", "In Progress", "To Do") and "Epic Link" = "https://velmeniai.atlassian.net/browse/epic" ORDER BY duedate ASC