Renders a summary statistics table showing the minimum, maximum, and average value for each column in a query result, with automatic type detection per column (integer, float, date, string, or null).
MINMAXTABLE — set as ReportType in def_report.
def Render(self, Param1="", Param2="", Param3="") -> str:
All three params (plus user, usergroups, usercompany) are substituted into self._Query via $param1$, $param2$, $param3$, $user$, $usergroups$, $usercompany$ placeholders. Data is fetched via RpcGetlist on page load and rendered into a Bootstrap striped table. Returns an HTML fragment with an embedded jQuery/RPC polling script. Refreshes every self._Refresh seconds when non-zero.
RpcGetlist(data)Executes the query, detects column types, and returns a list of dicts with keys Field, Min Value, Max Value, Average Value. Date averages are computed as the mean Unix timestamp and converted back to a date string.
Options read from self._Options JSON:
| Key | Effect |
|---|---|
columns |
Dict of column-option objects with label, width, align for table header customisation |
Type detection priority order: all-null, then float, integer, date, string. Uses python-dateutil for date parsing. Loads axion.rpc.js.