Database query to find the Customizer Scripts used in Dataplane reports.

This article provides the database query to find the Customizer Scripts used in the Dataplane reports.

 Instructions

1. Login to the Jira instance database.
   Consulting with the database administrator for guidance is recommended if one requires information about the database.

2. Run the following Jira database query to find the Customizer Scripts used in Dataplane reports.

   SELECT * FROM ( SELECT REPLACE("REPORT_KEY", 'reportKey.', '') as report_type, REGEXP_REPLACE("OPTIONS", '.*<reportConfigSelection><key>script</key><selectedValue><string>(.+?)</string></selectedValue>.*|^.*$', '\1') as script FROM "AO_6714C7_SAVED_REPORT_RECORD") as innerquery WHERE script <> '';

3. Sample output:

   report_type | script -------------------------------------+------------------------------------------------ issueValuesSnapshotsSumByDateReport | customizeChart { + | series ANY order 999 + | + | series "Open" order 1 + | series "Ready" order 2 + | series "In Progress" order 3 + | series "Blocked" order 4 + | series "In Review" order 5 + | series "Ready for Build" order 6+ | series "In QA" order 7 + | series "Done" order 8 + | } issueValuesSnapshotsSumByDateReport | customizeChart { + | series ANY order 999 + | + | series "Open" order 1 + | series "Ready" order 2 + | series "In Progress" order 3 + | series "Blocked" order 4 + | series "In Review" order 5 + | series "Ready for Build" order 6+ | series "In QA" order 7 + | series "Done" order 8 + | }

    

4. Sample screenshot from a third-party DB tool, DbVisualizer tool:
   
   

   Open