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 Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Fadoua M. Boualem
Published yesterday in Trello

Using Trello to manage events

As a Jira power user, I was at first doubtful that Trello could benefit my workflow. Jira already uses boards (ones you can customize!), so why would I even need to use Trello?! In this post you will...

447 views 6 7
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