Versions Compared

Old Version 2

changes.mady.by.user Sandeep Saluru

Saved on

compared with

New Version 3

changes.mady.by.user Rama Goberu

Saved on

Key

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

...

  1. Login to the Jira instance database. If one requires information about the database, consulting 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. Example 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. Example Sample screenshot from the DbVisualizer tool:

Info

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

...