Skip to main content


abstract class %CSP.UI.Portal.SQL.QButtons.Utils

This class contains shared methods used by the QButtons UI pages.

Property Inventory

Method Inventory


parameter DOMAIN = %Utility;


property SQLHomePage as %ZEN.Datatype.string [ InitialExpression = ..Link("%25CSP.UI.Portal.SQL.Home.zen") ];
Property methods: SQLHomePageDisplayToLogical(), SQLHomePageGet(), SQLHomePageIsValid(), SQLHomePageLogicalToDisplay(), SQLHomePageLogicalToOdbc(), SQLHomePageNormalize(), SQLHomePageSet()


classmethod CheckJobStatus(PID) as %ZEN.proxyObject [ ZenMethod ]
method DrawUpto40Text(pTable As %ZEN.Component.tablePane, pName As %String, pSeed As %String) as %Status
Write upto 40 characters of any field in tablePane
classmethod GetImportSchema(pNamespace, pRoutine, pCursor, pInternal=0) as %String [ ZenMethod ]
classmethod GetIndexAnalyzerProperties(Output pObject As %ZEN.proxyObject) as %Status
This method returns proxyObject that contains information for the UI
classmethod GetQueryData(pNamespace, pCursorName, pRoutineName, Output pObject As %ZEN.proxyObject) as %Status
This method returns information regarding a cached query for the UI.
classmethod GetQueryHistoryText(pID) as %String [ ZenMethod ]
Given a history ID, return query text
classmethod GetQueryText(pNamespace, pRoutine, pCursor, pInternal=0) as %String [ ZenMethod ]
Return PTools SQL Stats Query Text
classmethod GetSQLPageData(Output pObject As %ZEN.proxyObject) as %Status
Return json data for SQL page
classmethod GetSettingsData(Output pObject As %ZEN.proxyObject) as %Status
This method returns information regarding view stats settings for the UI.
method GetSettingsInfo(ByRef pParms, Output pObject As %RegisteredObject) as %Status
Return server info per View Stats.
classmethod JobShowPlan(query) as %ZEN.proxyObject [ ZenMethod ]
Method to job off Show Plan process in the background.
classmethod PrepareShowPlan(query, schema="", id="") as %String [ ZenMethod ]
classmethod PurgeQuery(pNamespace) as %ZEN.proxyObject [ ZenMethod ]
This method returns 1 (success) or 0 and clears cached queries.
clientmethod getSettingMessages(json) [ Language = javascript ]
Returns display messages for settings json should be passed in containing the settings data
clientmethod gotoPToolsPage(pageId) [ Language = javascript ]
Goto a particular page
clientmethod toggleClearText(tControl) [ Language = javascript ]
show or hide the Clear image for Query Text or Filter


FeedbackOpens in a new tab