This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRISOpens in a new window, see the InterSystems IRIS Migration Guide and Migrating to InterSystems IRIS, both available on the WRC Distributions pageOpens in a new window (login required).


class %CSP.UI.Portal.Dialog.SQLStatementDetails extends %CSP.UI.Portal.Dialog.WizardTemplate

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.

SQL Statement Details view and freeze plan for Management Portal

Property Inventory (Including Private)

Method Inventory (Including Private)


parameter APPLICATION = %CSP.UI.Portal.Application;
Class name of application this page belongs to.
parameter APPLYBUTTON = 1;
If true, then this dialog displays an Apply button.
parameter CSPURL = /csp/sys/exp/%CSP.UI.Portal.Dialog.SQLStatementDetails.zen;
Inherited description: This parameter is used to make sure that if multiple CSP applications are mapped to the same namespace that the CSP engine can correctly identify which class corresponds with which URL. If 'LockCSPName' is true (the default, defined in the CSP application) then you can only access this page if the url exactly matches this 'CSPURL'. You can set this parameter to "" if you wish to disable this check for this class. This check is applied for all CSP urls (cls/csp/zen).
If this page was compiled from a .csp file, then this parameter is automatically set to contain the url of this file used for compilation.
parameter PAGENAME = SQLStatementDetails;
Displayed name of this page.
parameter RESOURCE = %Development;
Security requirement

Properties (Including Private)

property NAMESPACE as %ZEN.Datatype.string (ZENURL = "NAMESPACE");
Property methods: NAMESPACEDisplayToLogical(), NAMESPACEGet(), NAMESPACEIsValid(), NAMESPACELogicalToDisplay(), NAMESPACELogicalToOdbc(), NAMESPACENormalize(), NAMESPACESet()
property SCHEMA as %ZEN.Datatype.string (ZENURL = "SCHEMA");
Schema name, may or may not be available.
Property methods: SCHEMADisplayToLogical(), SCHEMAGet(), SCHEMAIsValid(), SCHEMALogicalToDisplay(), SCHEMALogicalToOdbc(), SCHEMANormalize(), SCHEMASet()
property STMTHASH as %ZEN.Datatype.string (ZENURL = "STMTHASH");
Property methods: STMTHASHDisplayToLogical(), STMTHASHGet(), STMTHASHIsValid(), STMTHASHLogicalToDisplay(), STMTHASHLogicalToOdbc(), STMTHASHNormalize(), STMTHASHSet()
property colCompile as %ZEN.Datatype.caption [ InitialExpression = $$$Text("Compile Routine") ];
Store translated targetCol linkCaption for
Property methods: colCompileDisplayToLogical(), colCompileGet(), colCompileIsValid(), colCompileLogicalToDisplay(), colCompileLogicalToOdbc(), colCompileNormalize(), colCompileSet()

Methods (Including Private)

method %OnAfterCreatePage() as %Status
This callback is called after the server-side page object and all of its children are created.
Subclasses can override this to add, remove, or modify items within the page object model, or to provide values for controls.
method %OnGetSubtitle() as %String
Get the (localized) subtitle string for the dialog. This should be implemented in a subclass.
method %OnGetTitle() as %String
Get the (localized) title string for the dialog. This should be implemented in a subclass.
method ClearPlanError() as %Status [ ZenMethod ]
method ClearSQLStatistics() as %String [ ZenMethod ]
method CompileClassSetClassname(classname As %String) as %String [ ZenMethod ]
method CompileRoutineSetRoutineName(rtnname As %String) as %String [ ZenMethod ]
classmethod DrawShowPlan(foo) as %Status
method FreezePlan() as %String [ ZenMethod ]
method RecheckFrozenPlan() as %Status [ ZenMethod ]
method RefreshStatementMetadata() as %Status [ ZenMethod ]
method UnFreezePlan() as %String [ ZenMethod ]
clientmethod doCheckFrozen() [ Language = javascript ]
This client event is fired when the Check Frozen button is clicked
clientmethod doClearPlanError() [ Language = javascript ]
This client event is fired when the ClearPlanError button is clicked
clientmethod doClearStatistics() [ Language = javascript ]
clientmethod doCompileClass(classname, namespace) [ Language = javascript ]
clientmethod doCompileRoutine(rtnname, namespace) [ Language = javascript ]
clientmethod doFreezePlan() [ Language = javascript ]
clientmethod doRefreshPage() [ Language = javascript ]
This client event is fired when the Refresh button is clicked
clientmethod doRefreshTable(tablename) [ Language = javascript ]
clientmethod doUnFreezePlan() [ Language = javascript ]
clientmethod onPopupAction(popupName, action, value) [ Language = javascript ]
This client event is fired when the a popup page launched from this page fires an action. action - StatementRefresh is for when returning from compiling a routine or class.

Inherited Members

Inherited Properties (Including Private)

Inherited Methods (Including Private)

FeedbackOpens in a new window