Database query to find the types of chart formats used in the Dataplane app.

This article provides the database query to find the types of chart formats used in the Dataplane app.

 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 types of chart formats used in Dataplane.

   SELECT regexp_replace("OPTIONS", '.*<reportConfigSelection><key>reportChartFormat</key><selectedValue><string>(.+?)</string></selectedValue>.*|^.*$', '\1') as chart_format, COUNT(1) FROM "AO_6714C7_SAVED_REPORT_RECORD" GROUP BY chart_format ORDER BY count desc;

3. Sample output:

           chart_format        | count ----------------------------+-------  columnChart                |    58  areaChart                  |    56  barChart                   |    56                   lineChart                  |    22  verticalNonStackedBarChart |     9  pieChart                   |     4  maxMinChart                |     2  verticalBarChart           |     2  multiPieChart              |     1 (9 rows)

    

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

   Open