How to get custom fields with values using SQL Iin jira

Bhargavi Vasa
Contributor
July 15, 2024

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

1 answer

0 votes
Kris Dewachter
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 15, 2024

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
Contributor
July 16, 2024

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

Kris Dewachter
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 16, 2024

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

 

Screenshot 2024-07-16 at 11.51.18.png

Suggest an answer

Log in or Sign up to answer