This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Caché & Ensemble 2018.1.5 > Class Reference > ENSLIB namespace > %CSP.Util.SQLQueryPane


class %CSP.Util.SQLQueryPane extends %CSP.Util.TablePane

This class is used internally by Caché. You should not make direct use of it within your applications. There is no guarantee made about either the behavior or future operation of this class.

This pane displays the results of an SQL query within an HTML table.

Property Inventory

Method Inventory


parameter COLUMNDOMAIN = %UtilityColumns;
Default localization domain used for column headers
parameter COLUMNHELPDOMAIN = %UtilityColumnHelp;
Default localization domain used for column headers help messages


property LocalizeColumns as %Boolean [ InitialExpression = 1 ];
If true (default) run column name through localization
Property methods: LocalizeColumnsDisplayToLogical(), LocalizeColumnsGet(), LocalizeColumnsIsValid(), LocalizeColumnsLogicalToDisplay(), LocalizeColumnsLogicalToXSD(), LocalizeColumnsNormalize(), LocalizeColumnsSet(), LocalizeColumnsXSDToLogical()


method DrawBODY(pInstance As PageInstance) as %Status
Draw the BODY of the detail pane
method GetColorByColumn() as %String
Subclass can override this to specify the name of column used to distinctly color rows
classmethod LocalizeColumnName(pName As %String, Output pHelpMsg) as %String
Lookup a column name in the localization global and return localized version if present
method OnDrawHEADTablePane(pInstance As %CSP.Util.PageInstance) as %Status

Inherited Members

Inherited Properties

Inherited Methods