Script to retrieve the list of all estimation fields used by Planning Poker

This guide explains how to extract the list of all custom fields used by Planning Poker in a Jira Server/Data Center instance hosted on a PostgreSQL database.

Prerequisites

Access to the PostgreSQL database hosting your Jira instance.
Familiarity with the psql command-line tool or an equivalent database client.

Runbook

Connect to the database using psql command line tool and connect to the Jira schema:

The following runbook presents a connection to the docker container. To connect to db hosted as PostgreSQL server on the VM, please refer to KB : Connect Jira with PostgreSQL Database.

Execute the following script:

select 
"NAME" as game_name, 
"STORY_POINTS_FIELD_FULL"::json ->> 'id' as custom_field_ID, 
"STORY_POINTS_FIELD_FULL"::json ->> 'name' as custom_field_name 
from "AO_8496F9_POKER_GAME";

The query will return a list of all Planning Poker games with their associated custom field IDs and names. The output will look similar to the following: