Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?


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