Skip to main content


class %CSP.UI.Portal.SQL.CurrentStatements extends %CSP.UI.Portal.Utils

Property Inventory

Method Inventory


parameter AUTONS = 0;
Do not switch namespace for this page: it needs to stay in %SYS
parameter CSPURL = /csp/sys/op/%CSP.UI.Portal.SQL.CurrentStatements.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 HELPADDRESS = Home,SQL;
Inherited description: Each SMP page should set this link which points to the documentation anchor name.
parameter PAGENAME = Currently running SQL statements;
Displayed name of this page.
parameter RESOURCE = %Admin_Operate;
Security requirement


property Filter as %ZEN.Datatype.string;
Filter value user entered into the "Filter" field in the table navigator. This value is saved and reloaded for this page.
Property methods: FilterDisplayToLogical(), FilterGet(), FilterIsValid(), FilterLogicalToDisplay(), FilterLogicalToOdbc(), FilterNormalize(), FilterSet()
property PrevFilter as %ZEN.Datatype.string [ InitialExpression = "PrevFilter" ];
Previous Filter value
Property methods: PrevFilterDisplayToLogical(), PrevFilterGet(), PrevFilterIsValid(), PrevFilterLogicalToDisplay(), PrevFilterLogicalToOdbc(), PrevFilterNormalize(), PrevFilterSet()


Return the array of links to show in the locator bar.
method %OnAfterCreatePage() as %Status
Inherited description: Be sure to do ##super() when overriding.
method %OnGetPageName() as %String
Get the (localized) name of the page. This should be implemented in a subclass.
method CancelQuery(pid="", SQLStatementID="") as %Boolean [ ZenMethod ]
Cancel the specified SQL Query...
method CreateRS(Output tSC As %Status, pInfo As %ZEN.Auxiliary.QueryInfo) as %ResultSet
Create the ResultSet for to be displayed by this page...
method DrawDetails(seed As %String) as %Status
method DrawStatementExcerpt(table As %ZEN.Component.tablePane, name As %String, seed As %String) as %Status
method ExecuteRS(pRS As %Library.ResultSet, Output tSC As %Status, pInfo As %ZEN.Auxiliary.QueryInfo) as %Boolean
method GetTableRow(id) as %Integer [ ZenMethod ]
method OnDrawRibbon() as %Status
Add to the contents of the tool ribbon.
method OnGetRibbonInfo(Output pDisplay As %Boolean, Output pViewIcons As %List, Output pSortOptions As %List, Output pSearchBox As %Boolean, Output pRibbonTitle As %String, Output pCommands As %List) as %Status
Get information to display in the ribbon bar.
clientmethod filterChanged(value) [ Language = javascript ]
User entered something into the filter. Re-load the table with filter value.
Inherited description: Maybe overriden by subclass.
Inherited description: Maybe overriden by subclass.
clientmethod onloadHandler() [ Language = javascript ]
This client event, if present, is fired when the page is loaded.
clientmethod selectParent(id) [ Language = javascript ]
clientmethod selectRow(id) [ Language = javascript ]
clientmethod updateView() [ Language = javascript ]
Update / Reload table. This overrides the one in Portal.Utils.

Inherited Members

Inherited Properties

Inherited Methods

FeedbackOpens in a new tab