How can I get the value of the resolutiondate for a number of issues, without a plug-in.

[anthony sylvester]

Hi

I would like to see the resolutiondate for a number issues without using a plug-in. 

I don't have admin access to the system, however I need to produce a report that shows how long it is taking to close issues after they are opened. I know JIRA has a few gadgets that can show this. However I would like to export this information to Excel with the open and resolution date, so that I can produce some more detailed reports. 

Is this possible given my level of access to our JIRA server? (I only have admin access to my JIRA project, and not the server ) 

We are on JIRA v7.3.8

Thanks for your help

[Mohamed Benziane · Accepted solution]

Hi @anthony sylvester

If you have the right permission  to show all issue in your project, you can create a jql filter and use it in gadget or export the result list in to csv and make you change as you want.

Regards

[anthony sylvester]

Thanks @Mohamed Benziane for the reply. I do have permission to view and export the data. I just need to add the "Resolution Date" to the data that I will be exporting. do you know if that is possible?

[Mohamed Benziane]

hi, try to add the colum resolved in you search screen

[anthony sylvester]

Thanks @Mohamed Benziane :)

[Alexey Matveev]

Hello,

You can export issues to an csv file and load this file to Excel later. You can find more info here:

https://community.atlassian.com/t5/Jira-questions/how-to-export-to-csv/qaq-p/175115

[anthony sylvester]

Thanks @Alexey Matveev for the reply. I can export the results to an Excel file, I just can't seem the find a value for the "Resolution Date". is this field hidden from me?

I have been using this a simple JQL statment like this 

project = OSS and resolutiondate < now()

but it does not get me the resolutiondate value. and I will not know a date range to test for, when I'm pulling the data.