Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Exporting Filter to Excel Results in Blank Columns

Meredith Hogarth
Contributor
January 25, 2021

Hello, 

We are running into an issue when exporting a filter to Excel.  Some of the columns are showing up as blank or are missing data.  All the data is displayed correctly in the filter in the JIRA UI but when exporting to Excel the data is missing in the export. Sometimes the whole column, other times it is only missing on some rows.  It only seems to happen with custom fields.  

We are on Jira Cloud with all Next-Gen boards.  Any help is appreciated. Thanks! 

2 answers

0 votes
Oskar Austegard
Contributor
June 11, 2021

This is a logged issue "Gathering Interest" for 9 years: https://jira.atlassian.com/browse/JRASERVER-27641

AKA it won't be done soon/ever

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
April 1, 2016

Custom field changes are logged in the issue history, there's nothing to "activate" here.

The problem you've got is that "was in" doesn't support your custom field.

Ryan Anderson
April 10, 2019

Hey Nic,

Thanks for being such an active participant in this community. I'm not sure I understand your response to this inquiry. If "was in" doesn't support the custom field, what needs to be done to get "was in" to support it?

I also have a custom field named 'CI Validation' which is a select list (single choice) type of field. It has three options and I would like to do a historical search against this field. Yet every time I do I get the following error: "History searches do not support the 'CI Validation' field." 

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
April 18, 2019

Changes need to be made to the code that indexes the field, so that the history is indexed as welll as the current value, and then more code needs to be added into the JQL functionality for "was" so that it can use the historical values in the index.

Suggest an answer

Log in or Sign up to answer