Exporting to Excel with "Current Fields"

We have a user who is trying to export with excel based on "Current Fields". He has the fields active in the filter (multiple date time fields, to monitor SLA) but in the export those fields don't show up. Any idea?

9 answers

1 accepted

Comments Closed
0 votes

I'm not sure. 

I doubt the version of JIRA matters, but could you confirm it just on the off-chance?  (unless you're on 1 or 2 - they had some really strange oddities in filter exports, but the lowest I've seen in the last 5 years is 3.0.3)

I assume it's repeatable for that user, but does someone else exporting the same filter have the same problem?  And if someone else builds a different filter and includes some of the missing fields, do they lose them too on export?

Hi Robert,

have you tested it?

Yes I have tested it, the fields don't show up on the excel page.

Are these fields related to a plugin? or custom groovy scripts? or basic time/date fields?

They are basic custom date/time fields.

I'll let Nic take over.. (Hi @Nic Brough [Adaptavist] I've dropped you an sms buddy)

lol now we're both bothering him.

@Nic Brough [Adaptavist] little help buddy? smile

What do you mean by filter here? Are the fields displaying properly in the "JQL Search Page"? If Exporting All fields are working, it's probably something with the currently displayed fields. How many fields are you displaying right now? Can you provide screenshots of the JQL results.

Try this with the Better Excel add-on, possibly with more success.

i have also problem on exporting with current fields.

The export includes not the current fields of the view but the fields stored on the filter!

(JIRA 6.4.10)

 

Hi, working with columns in search result should help.

https://confluence.atlassian.com/jirasoftwarecloud/working-with-search-results-764478404.html 

You can configure output columns to your excel. 

 

Maybe the problem has something to do with a bug i was reporting some time ago.

https://jira.atlassian.com/browse/JRA-45752

Sadly Atlassian won't fix the bug sad

Has there been a resolution to it. I'm facing the same issue.

All the missing columns in my export ate Date columns custom fields.

But a couple of custom fields that are Date type are coming through. Am not sure on what basis its picking the columns to be exported into Excel.

Need urgent help with this please. 

Thanks.

 

Hello, have you tried this? https://confluence.atlassian.com/jirasoftwarecloud/working-with-search-results-764478404.html  It's about configuring columns for your filter to export.

I need more than 1,000 records exported. No way to do that either. 

Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,950 views 12 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot