Home > Class Reference > ENSLIB namespace > %CSP.Util.SQLQueryPane
Private  

%CSP.Util.SQLQueryPane

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

This class is used internally by InterSystems IRIS. 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.

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
2 1 4

Summary

Properties
Actions Align AutoRefresh CheckboxId
CommandFormClass CommandFormObject CommandSubmitPage Commands
Conditions FrameStyle HiddenColumns ItemsPerPage
LocalizeColumns MaxColumns MaxResults Name
Query SQLQuery ShowCheckboxes ShowFilter
ShowLastUpdate ShowRowNumbers ShowSearchPage ShowZebra
Sortable Styles Text URL
bgcolor border cellpadding cellspacing
enableAutoRefresh
Methods
%AddToSaveSet %ClassIsLatestVersion %ClassName %ConstructClone
%DispatchClassMethod %DispatchGetModified %DispatchGetProperty %DispatchMethod
%DispatchSetModified %DispatchSetMultidimProperty %DispatchSetProperty %Extends
%GetParameter %IsA %IsModified %New
%NormalizeObject %ObjectModified %OriginalNamespace %PackageName
%RemoveFromSaveSet %SerializeObject %SetModified %ValidateObject
CreateDataSet CreateResultSet CreateTempFile DrawBODY
DrawCommandForm DrawCommands DrawHEAD DrawLastUpdate
DrawSearch DrawStatusError DrawTable ExecuteResultSet
FilterTable GenerateCode GetColorByColumn GetDescriptiveText
GetItemsPerPage ItemsPerPageUpdate LocalizeColumnName LocalizeText
OnDrawFilter OnDrawHEADTablePane OnGenerateCode PurgeTempData
QuoteCOS RefreshTable XMLDTD XMLExport
XMLExportToStream XMLExportToString XMLNew XMLSchema
XMLSchemaNamespace XMLSchemaType
Subclasses
%CSP.UI.SQL.OpenPane %CSP.UI.SQL.QueryPane

Parameters

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

Properties

property LocalizeColumns as %Boolean [ InitialExpression = 1 ];
If true (default) run column name through localization

Methods

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