Sorry, your browser does not support JavaScript or JavaScript is disabled. Please enable JavaScript or use another browser to have a better experience.

Thanks for your feedback!
Need to tell us more? Click here or use the Feedback button.

Is this page helpful?

Class Details

Parameters (1)
Properties (1)
Methods (16)
Subclasses (8)

Show private members

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

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

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

Property Inventory

SQLHomePage

Method Inventory

CheckJobStatus()
DrawUpto40Text()
GetImportSchema()
GetIndexAnalyzerProperties()
GetQueryData()
GetQueryHistoryText()
GetQueryText()
GetSQLPageData()
GetSettingsData()
GetSettingsInfo()
JobShowPlan()
PrepareShowPlan()
PurgeQuery()
getSettingMessages()
gotoPToolsPage()
toggleClearText()

Parameters

parameter DOMAIN = %Utility;

Properties

property SQLHomePage as %ZEN.Datatype.string [ InitialExpression = ..Link("%25CSP.UI.Portal.SQL.Home.zen") ];

Property methods: SQLHomePageDisplayToLogical(), SQLHomePageGet(), SQLHomePageIsValid(), SQLHomePageLogicalToDisplay(), SQLHomePageLogicalToOdbc(), SQLHomePageNormalize(), SQLHomePageSet()

Methods

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

Subclasses

Feedback