How to get flat file export from JIRA structure board

Question

I've created structured board with all my issues starting from EPICs to Task and getting the result in hierarchical view which is all good. When I export data in to excel the same hierarchy is exported but when i apply filter the linked parent issues are not showing up.

For example, if filter is applied for user story the parent issues are not showing up. I would like to see all the epics which are related to user story.

Brant Schroeder · Accepted Answer

@Rama you will need to make sure that your filter does not remove the parent issues.  You can always add additional filters that use the OR statement to include the parent issues.

David Niro · Accepted Answer

Hello @Rama ,

David from ALM Works here.

In addition to what @Brant Schroeder has suggested, you could also add a formula column to your structure that you can then filter by in excel.

For example, if you need to filter by Status, you could try this:

IF (level != 1;
STATUS; 
level
)

Based on the hierarchy you describe, your Epic is level 1 and the Tasks would be level 2.  The formula looks at the level and determines that if the issue is not on level 1, it returns the Status of the issue and if It IS on level 1, it returns the level (1).

Now, when you export, you can filter by this column, choosing options for 1 and whatever Statuses you want to include in the filter.

I do have to ask, what need are you solving for by exporting to excel?  We love customer feedback and would be very interested in hearing about your use case!

Please let me know if this helps!

Best,
David