how to get unresolved resolution field when we export the issues in csv format?

Question

when we export the issues in jira as csv I want unresolved field should come in CSV file. but now what is happening is the issues which have proper resolution ex. fixed/resolved are visible in the CSV file but tickets which don't have the resolution, the resolution field in the CSV file is coming blank. How can I get the unresolved type of resolution in the CSV file?

Please look into the below screen where we have downloaded the report and in the resolution column we were getting unresolved field is available. which was happening in the jira 5.2 version. but now we have upgraded to jira 7.9.2 and now it's not happening.

This feature was removed in the latest version of jira?

Nic Brough -Adaptavist- · Answer

In 5.2, they were using the excel download which translated "<no value>" into "unresolved".  The CSV export does not translate, it just gives you what is really there.

Hema TB · Answer

@Nic Brough -Adaptavist-

Thanks for the reply. How can this possible in the older version of jira 5.2? One of our clients is complaining that in the newer version of jira unresolved in not available in the report. How is this possible?

Nic Brough -Adaptavist- · Answer

No, it's simply reporting what is there - "unresolved" is displayed by Jira when the field is *empty*.  The CSV does not do any translation, it just gives you the actual data (nothing)