...
\uD83D\uDCD8 Instructions
...
Login to the Jira instance database. If one requires information about the database, consulting with the database administrator for guidance is recommended.
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;
Example 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)
Example screenshot from the DbVisualizer tool:
Info |
---|
These are read-only commands, there is no modification of the database data. |
\uD83D\uDCCB Related articles
...