JSM-Data Center.is there a way to extract the values in the custom field in the excel sheet?

[Saqib Dar]

Hi,

JSM-Data Center.

is there a way to extract the values in the custom field in the excel sheet?

Thanks

[Mohamed Benziane]

Hi,

In the issue navigator you have an option to export the result of the JQL in excel.

https://confluence.atlassian.com/jirasoftwareserver/searching-for-issues-939938681.html#Searchingforissues-3.Workingwiththesearchresults

[Saqib Dar]

Hello @Mohamed Benziane

Thanks for your response.

JQL will give me the only value that is used in issues. Not all the values that custom field has.

I m looking for the way that will allow me to grap all listed values in the custom field.

For exam

I create a custom field "alpha"

I set value 

A

B

C

D

E

F

G

Now i want to export in a report all values of custom field "alpha"

[Mohamed Benziane]

Hi,

You can try the REST API

/rest/api/2/issue/<yourIssueKey>?expand=editmeta&fields=customfield_ID

https://confluence.atlassian.com/jirakb/how-to-retrieve-available-options-for-a-multi-select-customfield-via-jira-rest-api-815566715.html