Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

\uD83D\uDCD8 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.

    Code Block
    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:

    Code Block
            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 the a third-party DB tool, DbVisualizer tool:

Info
  • These are read-only commands, there is no modification of the database data.

...