Custom Field in Issue Search Columns Not Exporting to Excel

I have a custom field which is configured as Globel to all issue types, But when I try to export the Issues search using "Export Excel CSV (All fields)". This Custom field not exported. 

FYI: It only exported if the field isn't empty for any one of the issue, but Actually I need to include it in my result even if it's empty for all issues result.

 

Appreciate prompt response cause it's urgently needed.

1 answer

0 vote
Ignacio Pulgar Community Champion Dec 29, 2016

Workaround: As the omission of the field only occurs when there are no issues with a value in that field, why don't you add a foo issue with a value for that field, easily identifiable so that you can remove the line after the export?

Ignacio Pulgar Community Champion Dec 29, 2016

You may include that foo issue easily on your JQL search by adding:

...OR key = FOO-1

Or just add the empty column to the spreadsheet.

Ignacio Pulgar Community Champion Dec 29, 2016

Yeah, that's another possibility, and easily doable by opening and saving through a spreadsheet reader. The workaround of the foo issue is only better for editing the file through a text editor, like notepad++, as it would remove the need for intercalating any additional commas.

By the way, @Nic Brough [Adaptavist] I've just tried to install ScriptRunner on a free Cloud instance for Dev & testing purposes, but the license isn't considered a valid one, not even for the trial period.

Do you give ScriptRunner for JIRA Cloud for free by any means? (Dev environment, to Atlassian Experts...)

Actually, I'm a bit fuzzy on the details, and I don't know who's around to answer at the moment.  You can raise it at https://productsupport.adaptavist.com/servicedesk/customer/portal/2 but I've asked one of the team to have a look too.

Hi Ignacio,

As @Nic Brough [Adaptavist] mentioned, please raise an issue on our portal, but please use:

https://productsupport.adaptavist.com/servicedesk/customer/portals and find ScriptRunner for JIRA cloud.

regards, Mark.

Ah, sorry Mark, got the wrong bookmark here!

Ignacio Pulgar Community Champion Dec 29, 2016

Thanks Nic & Mark, I've tried to register through Mark's URL, but there's no option for doing so.

I've tried the 'Forgot my password' approach and, while the message about an email to reset my pass was being displayed, I've received nothing so far.

I think I've never had a customer account on that Service Desk. May you create one for me?

Ignacio Pulgar Community Champion Dec 29, 2016

My email is ignacio dot pulgar at incentro dot com

Suggest an answer

Log in or Join to answer
Community showcase
Emilee Spencer
Published Friday in Marketplace Apps

Marketplace Spotlight: DeepAffects

Hello Atlassian Community! My name is Emilee, and I’m a Product Marketing Manager for the Marketplace team. Starting with this post, I'm kicking off a monthly series of Spotlights to highlight Ma...

64 views 0 3
Read article

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