This block allows you to include real-time embedded analytics using many types of visualization.
The block setup is simple and requires just a single property:
| Property | Example Usage | Description |
|
Data provider function |
xxx_my_package.some_chart_xml | The PL/SQL function that returns the chart table data in XML format |
The PL/SQL function must exist and confirm to this specification:
The function should return the chart table data in XML format. This is typically generated in a SQL statement using standard Oracle XMLDB SQL Functions such as XMLElement, XMLAttributes, XMLForest and XMLAgg.
Although the output is provided in XML format, it is converted to JSON in the REST APIs. You can see the output in JSON using the following SQL function:
xxas_com_json_pkg.xml_to_json_clob(<XMLType instance>)
Sample XML output is provided in Chart data table examples. The charts are powered by Google Charts and come with many options; you will likely need to refer to the Google Chart documentation to implement charts that vary from the given examples.