-
Suggestion
-
Resolution: Unresolved
-
None
-
40
-
2
-
Issue Summary
This is reproducible on Data Center:
In Jira Cloud, when exporting the result set from a filter as a CSV file, if the column Parent is empty for all issues in the result set, that column is not exported.
It would be better to export the column Parent whenever it is added to a filter, regardless of whether it is empty for all issues or not. This inconsistency becomes problematic when the exported CSV file is used for data processing in external systems where a specific sequence of columns is expected.
Steps to Reproduce
- Create a Jira Software project (e.g., FOO).
- Create multiple issues with different issue types in the project FOO, none of them having any parent/child relationship.
- Create an issue as an Epic (e.g., FOO-8), and another issue as a Story (e.g., FOO-9), which is a child of the issue FOO-8.
- Create a filter with the following JQL:
project = FOO ORDER BY Rank ASC
- Add the column Parent to that filter in all three options: My defaults, Filter, and System.
- Export the result set of that filter with the option Export CSV (my defaults):
- The column Parent is exported, as expected.
- Change the JQL of that filter to:
project = FOO AND issue NOT IN(FOO-9) ORDER BY Rank ASC
- Export the result set of that filter with the option Export CSV (filter fields):
- The column Parent is not exported.
Expected Results
The column Parent is exported to the CSV file even if it is empty for all the selected issues from the filter.
Actual Results
The column Parent is not exported to the CSV file if it is empty for all the selected issues from the filter.
Workaround
If the exported CSV file must have a specific sequence of columns:
- Import it into a spreadsheet processor such as Microsoft Excel or Google Sheets.
- Manually add the required columns with empty values for each entry.
- Export it as a new CSV file.