Class %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


[USER] > [%CSP] > [Util] > [SQLQueryPane]		Private Storage