How to get custom fields with values using SQL Iin jira

[Bhargavi Vasa]

I am looking for SQL to get custom fields with values in jira for issues

Jira version : 8.20.5

Projectkey,issuekey,customfieldname,customfieldid,customfieldvalue

[Kris Dewachter]

Hi @Bhargavi Vasa ,

Can you describe more in detail on what you are trying to achieve ?

You can use JQL to find the issues you need, and configure the columns in the list view.

Best regards,

Kris

[Bhargavi Vasa]

I am looking for SQL to get custom fields in a project with their values for all the issues in that project

[Kris Dewachter]

The quickest way to do it to export the issues via JQL. Export the issues to an Excel or CSV file with all fields. You can select the information you need from within the Excel file