Renders an interactive pivot table powered by the pivottable.js library, with data loaded asynchronously via RPC.
PivotTable — set as ReportType in def_report.
def Render(self, Param1="", Param2="", Param3="") -> str:
Param1 / Param2 / Param3 — passed to the RPC call and substituted into the report query via $param1$, $param2$, $param3$.
Returns an HTML <div> and inline <script> that call RemoteProcedureCall to fetch data via RpcGetlist, then render it with $.fn.pivotUI. The pivot table is re-polled on a configurable interval and only redrawn when the data changes.
RpcGetlist(data)Executes the report query with $param1$, $param2$, $param3$, $user$, and $usergroups$ substituted, and returns the result set as a list of dicts for the pivot table.
Options read from self._Options JSON:
refresh — polling interval in milliseconds; omit to disable auto-refreshinitial_options — JSON object of initial pivotUI configuration (rows, cols, aggregator, etc.)Requires axion.rpc.js, pivot.min.css, and the following CDN resources: jQuery UI, jquery.ui.touch-punch, pivottable.js, and tips_data.min.js.