Renders an interactive reference table of all SQL calculations in a calculation group, with syntax-highlighted SQL and resolved token values.
CALCULATION — set as ReportType in def_report.
def Render(self, Param1="", Param2="", Param3="") -> str:
Param1 — the CalculationGroup to display; queries def_calculations WHERE CalculationGroup = Param1 ORDER BY Rank.Param2 — optional GUID / param1 context used to resolve $guid$ and $param1$ tokens within the SQL. When provided, token values are fetched via process_text and displayed alongside the SQL.Returns an HTML table listing each calculation's name, description, extracted $token$ references, and formatted SQL code block.
Loads highlight.js 11.9 (atom-one-light theme) from cdnjs for SQL syntax highlighting. Uses sqlparse to format and detect SQL statement types. Token placeholders of the form $name$ are extracted from CalculationSql and shown as labelled badges.