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

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

Owned by Avinash Bhagawati
Last updated: Dec 12, 2024 by Derya Özdemir
1 min read

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

  1. 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.

  1. 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:

 

Related content