%CSP.UI.Portal.SQL.Home
class %CSP.UI.Portal.SQL.Home extends %CSP.UI.Template.Property, %CSP.UI.Portal.UtilsNav
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.
Zen page for System Management Portal - Home for SQLProperty Inventory
- BuilderPage
- CurrentCatalog
- CurrentItem
- CurrentStatementPage
- DEPRECATEDFLAG
- Dialect
- DocBookPage
- DocumaticPage
- FILTERPROC
- FILTERSCHEMA
- FILTERTYPE
- Foreground
- MaxRows
- NAMESPACE
- ObjectSelectMode
- OpenRoutinePage
- OpenTablePage
- OpenViewPage
- PrintDetailsPage
- RuntimeMode
- SQLFILTER
- SQLHomePage
- SQLParametersPage
- SQLStatementDetailsPage
- SQLViewPage
- SYSTEMFLAG
- ShowRowNum
- StatementFilter
- StatementMaxRows
- StatementPageSize
- StatementRadioSelect
- TuneAllTablePage
- TuneTablePage
- enableAutoRefresh
- iconFolder
- msgDeleteCQNamespace
- msgDeleteCQTable
- msgSelectTable
- processID
Method Inventory
- %OnAfterCreatePage()
- %OnFinishBackgroundTask()
- %OnGetPageName()
- %OnMonitorBackgroundTask()
- CancelQuery()
- DeleteHistory()
- DeleteHistoryAll()
- DeleteQuery()
- DrawCQDetails()
- DrawGlobalLink()
- DrawHTML()
- DrawPerformance()
- DrawProcedureDetails()
- DrawShowPlan()
- DrawTableDetails()
- DrawTableHeader()
- DrawToggleIndexStatus()
- DrawViewDetails()
- Drop()
- GetCQText()
- GetCQs()
- GetExpandState()
- GetLastTreeLoaded()
- GetProcedures()
- GetRecentList()
- GetSQLInfo()
- GetStatus()
- GetTableFields()
- GetTables()
- GetText()
- GetTreeInfo()
- GetViews()
- ListSchemas()
- OnGetRibbonInfo()
- OpenTableMaxRowsUpdate()
- ParseTextPiece()
- PrepareAction()
- PrepareDeletion()
- PrepareQuery()
- Quoter2()
- RebuildIndices()
- RefreshTableStatements()
- SaveExpandState()
- SaveFilter()
- SaveLastTreeLoaded()
- SaveParameters()
- SaveQueryHistory()
- StartQuery()
- StartQueryExecution()
- StatementIndexClean()
- TableFields()
- UpdateTableNavState()
- adjustSizes()
- deleteSelectedQuery()
- doAction()
- doActionTable()
- doAllSchemas()
- doDeleteAll()
- doDrill()
- doExecute()
- doFilterType()
- doHistory()
- doInprogress()
- doOpenDoc()
- doOpenTableMax()
- doQueryBuilder()
- doRebuildIndex()
- doReferenceTo()
- doReloadNode()
- doSearch()
- doSelectRow()
- doShowPlan()
- doStatementDetailsTo()
- doTree()
- getTable()
- historyFilterChanged()
- keyUp()
- keyUpQueryText()
- navMaxRowsChanged()
- navPageSizeChanged()
- onPopupAction()
- onlayoutHandler()
- onloadHandler()
- prepareProp()
- selectCQ()
- selectHistory()
- selectSchema()
- showCQ()
- showCQTable()
- showCatalog()
- showCatalogCQ()
- showCatalogProc()
- showCatalogView()
- showExpand()
- showStatement()
- showStatementTable()
- showStatements()
- statementFilterChanged()
- statementRefresh()
- tabChanged()
- tableDropHandler()
- timeout()
- toggleClearText()
- toggleIndexStatus()
- toggleOptions()
- toggleSearch()
- updateParameters()
- updateStatistics()
- updateTreeItems()
- validateText()
Parameters
parameter AUTONS = 1;
Switch namespace $NAMESPACE is present
parameter CSPURL = /csp/sys/exp/%CSP.UI.Portal.SQL.Home.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.
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 = SQL Home Page;
Displayed name of this page.
parameter RESOURCE = %Development;
Security requirement
Properties
property BuilderPage as %ZEN.Datatype.string [ InitialExpression = ..Link("/csp/sys/exp/%25CSP.UI.SQL.QueryBuilderWindow.cls",,1) ];
Link pages
Property methods: BuilderPageDisplayToLogical(), BuilderPageGet(), BuilderPageIsValid(), BuilderPageLogicalToDisplay(), BuilderPageLogicalToOdbc(), BuilderPageNormalize(), BuilderPageSet()
property CurrentCatalog as %Integer;
current user selected catalog type - updated when user clicked on a tree node. -1=Nothing selected; 0=Table; 1=SystemTable; 2=View; 3=Procedure; 4=Cached Query
Property methods: CurrentCatalogDisplayToLogical(), CurrentCatalogGet(), CurrentCatalogIsValid(), CurrentCatalogLogicalToDisplay(), CurrentCatalogNormalize(), CurrentCatalogSet(), CurrentCatalogXSDToLogical()
property CurrentItem as %String;
current item (value) selected from the tree
Property methods: CurrentItemDisplayToLogical(), CurrentItemGet(), CurrentItemIsValid(), CurrentItemLogicalToDisplay(), CurrentItemLogicalToOdbc(), CurrentItemNormalize(), CurrentItemSet()
property CurrentStatementPage as %ZEN.Datatype.string [ InitialExpression = ..Link("/csp/sys/op/%25CSP.UI.Portal.SQL.CurrentStatements.zen",,1) ];
Property methods: CurrentStatementPageDisplayToLogical(), CurrentStatementPageGet(), CurrentStatementPageIsValid(), CurrentStatementPageLogicalToDisplay(), CurrentStatementPageLogicalToOdbc(), CurrentStatementPageNormalize(), CurrentStatementPageSet()
property DEPRECATEDFLAG as %Integer [ InitialExpression = "0" ];
Whether to include deprecated items
Property methods: DEPRECATEDFLAGDisplayToLogical(), DEPRECATEDFLAGGet(), DEPRECATEDFLAGIsValid(), DEPRECATEDFLAGLogicalToDisplay(), DEPRECATEDFLAGNormalize(), DEPRECATEDFLAGSet(), DEPRECATEDFLAGXSDToLogical()
property Dialect as %ZEN.Datatype.string [ InitialExpression = "IRIS" ];
SQL dialect used to prepare dynamic SQL statements
Property methods: DialectDisplayToLogical(), DialectGet(), DialectIsValid(), DialectLogicalToDisplay(), DialectLogicalToOdbc(), DialectNormalize(), DialectSet()
property DocBookPage as %ZEN.Datatype.string [ InitialExpression = ..Link("/csp/docbook/DocBook.UI.Page.zen",,1) ];
Property methods: DocBookPageDisplayToLogical(), DocBookPageGet(), DocBookPageIsValid(), DocBookPageLogicalToDisplay(), DocBookPageLogicalToOdbc(), DocBookPageNormalize(), DocBookPageSet()
property DocumaticPage as %ZEN.Datatype.string [ InitialExpression = ..Link("/csp/documatic/%25CSP.Documatic.cls",,1) ];
Property methods: DocumaticPageDisplayToLogical(), DocumaticPageGet(), DocumaticPageIsValid(), DocumaticPageLogicalToDisplay(), DocumaticPageLogicalToOdbc(), DocumaticPageNormalize(), DocumaticPageSet()
property FILTERPROC as %Integer;
Possible values: 1, 2, 3, 4, 5 (Functions & Queries, Functions & Queries & Extent, Functions, Queries, Queries & Extent)
Property methods: FILTERPROCDisplayToLogical(), FILTERPROCGet(), FILTERPROCIsValid(), FILTERPROCLogicalToDisplay(), FILTERPROCNormalize(), FILTERPROCSet(), FILTERPROCXSDToLogical()
property FILTERSCHEMA as %Integer;
User selected schema
Property methods: FILTERSCHEMADisplayToLogical(), FILTERSCHEMAGet(), FILTERSCHEMAIsValid(), FILTERSCHEMALogicalToDisplay(), FILTERSCHEMANormalize(), FILTERSCHEMASet(), FILTERSCHEMAXSDToLogical()
property FILTERTYPE as %String;
Possible values: Tables, Views, Procedures, CQs
Property methods: FILTERTYPEDisplayToLogical(), FILTERTYPEGet(), FILTERTYPEIsValid(), FILTERTYPELogicalToDisplay(), FILTERTYPELogicalToOdbc(), FILTERTYPENormalize(), FILTERTYPESet()
property Foreground as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
Whether to execute the SQL query in the foreground
Property methods: ForegroundDisplayToLogical(), ForegroundGet(), ForegroundIsValid(), ForegroundLogicalToDisplay(), ForegroundLogicalToOdbc(), ForegroundLogicalToXSD(), ForegroundNormalize(), ForegroundSet(), ForegroundXSDToLogical()
property MaxRows as %ZEN.Datatype.string [ InitialExpression = "1000" ];
Maximum rows to display in result tables
Property methods: MaxRowsDisplayToLogical(), MaxRowsGet(), MaxRowsIsValid(), MaxRowsLogicalToDisplay(), MaxRowsLogicalToOdbc(), MaxRowsNormalize(), MaxRowsSet()
property NAMESPACE as %String (ZENURL = "$NAMESPACE");
Current namespace
Property methods: NAMESPACEDisplayToLogical(), NAMESPACEGet(), NAMESPACEIsValid(), NAMESPACELogicalToDisplay(), NAMESPACELogicalToOdbc(), NAMESPACENormalize(), NAMESPACESet()
property ObjectSelectMode as %Integer [ InitialExpression = 0 ];
Specify how columns whose type class is a swizzleable class
will be defined in the result set class generated from a SELECT statement.
Currently it is always set to 0.
Property methods: ObjectSelectModeDisplayToLogical(), ObjectSelectModeGet(), ObjectSelectModeIsValid(), ObjectSelectModeLogicalToDisplay(), ObjectSelectModeNormalize(), ObjectSelectModeSet(), ObjectSelectModeXSDToLogical()
property OpenRoutinePage as %ZEN.Datatype.string [ InitialExpression = ..Link("/csp/sys/exp/%25CSP.UI.System.ViewCode.cls",,1) ];
Property methods: OpenRoutinePageDisplayToLogical(), OpenRoutinePageGet(), OpenRoutinePageIsValid(), OpenRoutinePageLogicalToDisplay(), OpenRoutinePageLogicalToOdbc(), OpenRoutinePageNormalize(), OpenRoutinePageSet()
property OpenTablePage as %ZEN.Datatype.string [ InitialExpression = ..Link("/csp/sys/exp/UtilSqlOpen.csp",,1) ];
Property methods: OpenTablePageDisplayToLogical(), OpenTablePageGet(), OpenTablePageIsValid(), OpenTablePageLogicalToDisplay(), OpenTablePageLogicalToOdbc(), OpenTablePageNormalize(), OpenTablePageSet()
property OpenViewPage as %ZEN.Datatype.string [ InitialExpression = ..Link("/csp/sys/exp/UtilSqlOpenView.csp",,1) ];
Property methods: OpenViewPageDisplayToLogical(), OpenViewPageGet(), OpenViewPageIsValid(), OpenViewPageLogicalToDisplay(), OpenViewPageLogicalToOdbc(), OpenViewPageNormalize(), OpenViewPageSet()
property PrintDetailsPage as %ZEN.Datatype.string [ InitialExpression = ..Link("%CSP.UI.Portal.SQL.PrintTable.zen",,1) ];
Property methods: PrintDetailsPageDisplayToLogical(), PrintDetailsPageGet(), PrintDetailsPageIsValid(), PrintDetailsPageLogicalToDisplay(), PrintDetailsPageLogicalToOdbc(), PrintDetailsPageNormalize(), PrintDetailsPageSet()
property RuntimeMode as %ZEN.Datatype.string [ InitialExpression = "2" ];
Default is Display Mode
Property methods: RuntimeModeDisplayToLogical(), RuntimeModeGet(), RuntimeModeIsValid(), RuntimeModeLogicalToDisplay(), RuntimeModeLogicalToOdbc(), RuntimeModeNormalize(), RuntimeModeSet()
property SQLFILTER as %String;
String user entered to filter the tree.
Property methods: SQLFILTERDisplayToLogical(), SQLFILTERGet(), SQLFILTERIsValid(), SQLFILTERLogicalToDisplay(), SQLFILTERLogicalToOdbc(), SQLFILTERNormalize(), SQLFILTERSet()
property SQLHomePage as %ZEN.Datatype.string [ InitialExpression = ..Link("%25CSP.UI.Portal.SQL.Home.zen",,1) ];
Property methods: SQLHomePageDisplayToLogical(), SQLHomePageGet(), SQLHomePageIsValid(), SQLHomePageLogicalToDisplay(), SQLHomePageLogicalToOdbc(), SQLHomePageNormalize(), SQLHomePageSet()
property SQLParametersPage as %ZEN.Datatype.string [ InitialExpression = ..Link("%CSP.UI.Portal.Dialog.SQLParametersPrompt.zen",,1) ];
Property methods: SQLParametersPageDisplayToLogical(), SQLParametersPageGet(), SQLParametersPageIsValid(), SQLParametersPageLogicalToDisplay(), SQLParametersPageLogicalToOdbc(), SQLParametersPageNormalize(), SQLParametersPageSet()
property SQLStatementDetailsPage as %ZEN.Datatype.string [ InitialExpression = ..Link("_CSP.UI.Portal.Dialog.SQLStatementDetails.zen",,1) ];
Property methods: SQLStatementDetailsPageDisplayToLogical(), SQLStatementDetailsPageGet(), SQLStatementDetailsPageIsValid(), SQLStatementDetailsPageLogicalToDisplay(), SQLStatementDetailsPageLogicalToOdbc(), SQLStatementDetailsPageNormalize(), SQLStatementDetailsPageSet()
property SQLViewPage as %ZEN.Datatype.string [ InitialExpression = ..Link("%CSP.UI.Portal.Dialog.SQLView.zen",,1) ];
Property methods: SQLViewPageDisplayToLogical(), SQLViewPageGet(), SQLViewPageIsValid(), SQLViewPageLogicalToDisplay(), SQLViewPageLogicalToOdbc(), SQLViewPageNormalize(), SQLViewPageSet()
property SYSTEMFLAG as %Integer [ InitialExpression = "0" ];
Whether to include System items
Property methods: SYSTEMFLAGDisplayToLogical(), SYSTEMFLAGGet(), SYSTEMFLAGIsValid(), SYSTEMFLAGLogicalToDisplay(), SYSTEMFLAGNormalize(), SYSTEMFLAGSet(), SYSTEMFLAGXSDToLogical()
property ShowRowNum as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
Whether to show row numbers in result tables
Property methods: ShowRowNumDisplayToLogical(), ShowRowNumGet(), ShowRowNumIsValid(), ShowRowNumLogicalToDisplay(), ShowRowNumLogicalToOdbc(), ShowRowNumLogicalToXSD(), ShowRowNumNormalize(), ShowRowNumSet(), ShowRowNumXSDToLogical()
property StatementFilter as %ZEN.Datatype.string;
Filter used for Statements table
Property methods: StatementFilterDisplayToLogical(), StatementFilterGet(), StatementFilterIsValid(), StatementFilterLogicalToDisplay(), StatementFilterLogicalToOdbc(), StatementFilterNormalize(), StatementFilterSet()
property StatementMaxRows as %ZEN.Datatype.integer [ InitialExpression = 1000 ];
Maximum rows to display in Statements table
Property methods: StatementMaxRowsDisplayToLogical(), StatementMaxRowsGet(), StatementMaxRowsIsValid(), StatementMaxRowsLogicalToDisplay(), StatementMaxRowsLogicalToOdbc(), StatementMaxRowsNormalize(), StatementMaxRowsSet()
property StatementPageSize as %ZEN.Datatype.integer [ InitialExpression = 100 ];
PageSize used to display in Statements table
Property methods: StatementPageSizeDisplayToLogical(), StatementPageSizeGet(), StatementPageSizeIsValid(), StatementPageSizeLogicalToDisplay(), StatementPageSizeLogicalToOdbc(), StatementPageSizeNormalize(), StatementPageSizeSet()
property StatementRadioSelect as %ZEN.Datatype.string [ InitialExpression = "statementTable0" ];
Holds the selected redio option on the SQL Statements display
Property methods: StatementRadioSelectDisplayToLogical(), StatementRadioSelectGet(), StatementRadioSelectIsValid(), StatementRadioSelectLogicalToDisplay(), StatementRadioSelectLogicalToOdbc(), StatementRadioSelectNormalize(), StatementRadioSelectSet()
property TuneAllTablePage as %ZEN.Datatype.string [ InitialExpression = ..Link("%CSP.UI.Portal.Dialog.SQLTuneTables.zen",,1) ];
Property methods: TuneAllTablePageDisplayToLogical(), TuneAllTablePageGet(), TuneAllTablePageIsValid(), TuneAllTablePageLogicalToDisplay(), TuneAllTablePageLogicalToOdbc(), TuneAllTablePageNormalize(), TuneAllTablePageSet()
property TuneTablePage as %ZEN.Datatype.string [ InitialExpression = ..Link("%CSP.UI.Portal.SQL.TuneTable.zen",,1) ];
Property methods: TuneTablePageDisplayToLogical(), TuneTablePageGet(), TuneTablePageIsValid(), TuneTablePageLogicalToDisplay(), TuneTablePageLogicalToOdbc(), TuneTablePageNormalize(), TuneTablePageSet()
property enableAutoRefresh as %ZEN.Datatype.boolean [ InitialExpression = 1 ];
True if pages in the management portal are permitted to use auto-refresh behaviour.
Property methods: enableAutoRefreshDisplayToLogical(), enableAutoRefreshGet(), enableAutoRefreshIsValid(), enableAutoRefreshLogicalToDisplay(), enableAutoRefreshLogicalToOdbc(), enableAutoRefreshLogicalToXSD(), enableAutoRefreshNormalize(), enableAutoRefreshSet(), enableAutoRefreshXSDToLogical()
property iconFolder as %ZEN.Datatype.string [ InitialExpression = ..Link("/csp/broker/deepsee/folder_16.png") ];
icon used for major branch folder at the top level, such as Tables and Views
Property methods: iconFolderDisplayToLogical(), iconFolderGet(), iconFolderIsValid(), iconFolderLogicalToDisplay(), iconFolderLogicalToOdbc(), iconFolderNormalize(), iconFolderSet()
property msgDeleteCQNamespace as %ZEN.Datatype.caption [ InitialExpression = $$$TextJS("Are you sure you want to delete ALL cached queries in namespace %1?") ];
Property methods: msgDeleteCQNamespaceDisplayToLogical(), msgDeleteCQNamespaceGet(), msgDeleteCQNamespaceIsValid(), msgDeleteCQNamespaceLogicalToDisplay(), msgDeleteCQNamespaceLogicalToOdbc(), msgDeleteCQNamespaceNormalize(), msgDeleteCQNamespaceSet()
property msgDeleteCQTable as %ZEN.Datatype.caption [ InitialExpression = $$$TextJS("Are you sure you want to delete all cached queries for table %1?") ];
Property methods: msgDeleteCQTableDisplayToLogical(), msgDeleteCQTableGet(), msgDeleteCQTableIsValid(), msgDeleteCQTableLogicalToDisplay(), msgDeleteCQTableLogicalToOdbc(), msgDeleteCQTableNormalize(), msgDeleteCQTableSet()
property msgSelectTable as %ZEN.Datatype.caption [ InitialExpression = $$$TextJS("Please select a Table from the tree and try again.") ];
Property methods: msgSelectTableDisplayToLogical(), msgSelectTableGet(), msgSelectTableIsValid(), msgSelectTableLogicalToDisplay(), msgSelectTableLogicalToOdbc(), msgSelectTableNormalize(), msgSelectTableSet()
property processID as %ZEN.Datatype.string [ InitialExpression = $JOB ];
Current Process ID ($JOB)
Property methods: processIDDisplayToLogical(), processIDGet(), processIDIsValid(), processIDLogicalToDisplay(), processIDLogicalToOdbc(), processIDNormalize(), processIDSet()
Methods
method %OnAfterCreatePage() as %Status
Inherited description: Be sure to do ##super() when overriding.
Inherited description: This server-side callback method is called whenever the client
calls to monitor the current background task and the task is complete.
Typically a subclass uses this to send back JavaScript to update
the page.
method %OnGetPageName() as %String
Get the (localized) name of the page.
This should be implemented in a subclass.
classmethod %OnMonitorBackgroundTask(pTaskID As %String, pStatus As %String, pPercentComplete As %Float)
Inherited description: This server-side callback method is called whenever the client
calls to monitor the current background task.
Typically a subclass uses this to send back JavaScript to update
a progress bar.
method CancelQuery() as %Boolean [ ZenMethod ]
classmethod DeleteHistory(pID) as %String [ ZenMethod ]
classmethod DeleteHistoryAll() [ ZenMethod ]
classmethod DeleteQuery(FILETYPE, selectedRows) as %String [ ZenMethod ]
FILETYPE = "PurgeCQNamespace", "PurgeCQTable", or "PurgeCQRoutines"
classmethod DrawCQDetails(pSeed) as %Status
Draw html for Cached Query details
classmethod DrawGlobalLink(table As %ZEN.Component.tablePane, name As %String, seed As %String) as %Status
Draw HTML link to View Global Contents page
Draw HTML for Execute Query result.
classmethod DrawPerformance(pSeed) as %Status
classmethod DrawProcedureDetails(pSeed) as %Status
Draw html for Procedure detiails
classmethod DrawTableDetails(pSeed) as %Status
Draw HTML for Table info and build link for Class documatic.
Draw the contents of the Table Header (the region between the diagram and the table).
classmethod DrawToggleIndexStatus(table As %ZEN.Component.tablePane, name As %String, seed As %String) as %Status
Draw link to toggle map selectability
classmethod DrawViewDetails(pSeed) as %Status
classmethod Drop(pDropType, pSchema, pTable) as %String [ ZenMethod ]
Drop a Table, View, Procedure, or CachedQuery
classmethod GetCQText(pRoutine) as %String [ ZenMethod ]
Given cached query routine name, return query text
classmethod GetCQs(pShowSystem, pFilter, pSchema, pTotalNumber, ByRef pTree) as %Integer
Build array for Cached Queries tree.
If schema is not null then use CachedQueryInfo that takes in the schema name and get routines(classes) that belong to that schema.
If filter is not null then match routine name to that filter.
classmethod GetExpandState(FILETYPE) as %String
classmethod GetLastTreeLoaded() as %String [ ZenMethod ]
classmethod GetProcedures(pShowSystem, pFilter, pFilterOption, pTotalNumber, pDeprecated, ByRef pTree) as %Integer
Build array for Procedures tree
classmethod GetRecentList(FILTERTYPE) as %String [ ZenMethod ]
method GetSQLInfo(ByRef pParms, Output pObject As %RegisteredObject) as %Status
******** End of Special Code for Expand *************
Return json for info.
classmethod GetStatus(pCurrentQueryID As %Integer = "") as %ZEN.proxyObject [ ZenMethod ]
when DrawHTML is finished, Status is "Done" then we update the Performance value.
classmethod GetTableFields(pSchemaNumber, pTableLevel, pTableName, ByRef pTree) as %Integer
Build field array for a table
classmethod GetTables(pShowSystem, pFilter, pSchemaNumber, pDeprecated, ByRef pTree) as %Integer
Build array for Tables tree
classmethod GetText(pID) as %String [ ZenMethod ]
Given a history ID, return query text
Provide contents of the data source tree.
classmethod GetViews(pShowSystem, pFilter, pTotalNumber, pDeprecated, ByRef pTree) as %Integer
Build array for Views tree
method ListSchemas(pRS As %Library.ResultSet, Output tSC As %Status, pInfo As %ZEN.Auxiliary.QueryInfo) as %Boolean
Method for executing the query for list schemas.
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
Curently we do not display the ribbon for this page.
classmethod OpenTableMaxRowsUpdate(pMax) [ ZenMethod ]
classmethod ParseTextPiece(n, tLine)
Parse $C(10) from each line of query text and put into session array
classmethod PrepareAction(pText) as %String [ ZenMethod ]
Save user's latest query text into global for later execution
classmethod PrepareDeletion(FILETYPE, selectedRows) as %String [ ZenMethod ]
Save selected cached query routines into %session
FILETYPE = "PurgeCQRoutines"
classmethod PrepareQuery(pText, pRuntimeMode, pDialect, pObjectSelectMode) as %String [ ZenMethod ]
Prepare to execute query.
Save user's latest query text into global for later execution
Return number of parameters the query text may have.
classmethod Quoter2(val) as %String [ ZenMethod ]
This functions takes a table/view schema.name and quote either piece if needed
classmethod RebuildIndices(pSchema, pTable, pIndex="") as %String [ ZenMethod ]
clientmethod RefreshTableStatements() [ Language = javascript ]
show catalog details for a table
classmethod SaveExpandState(FILETYPE, searchExpanded) [ ZenMethod ]
classmethod SaveFilter(FILETYPE, SQLFILTER, FILTERPROC, SYSTEMFLAG, DEPRECATEDFLAG) as %Boolean [ ZenMethod ]
FILTERTYPE is any of the choices from Filter drop-down.
classmethod SaveLastTreeLoaded(pBranch, pTotalNumber) as %String
classmethod SaveParameters(RuntimeMode, MaxRows, ShowRowNum, Dialect, ObjectSelectMode, Foreground) [ ZenMethod ]
classmethod StartQueryExecution(pRunInBackground As %Boolean = 1, pQueryID As %Integer, pRuntimeMode As %String, pDialect As %String, pObjectSelectMode As %Integer, pShowRowNum As %Boolean, pMaxRows As %Integer) as %Status
classmethod StatementIndexClean() [ ZenMethod ]
Call logic to cleanup stale statement index entries that do not have routines/classes anymore
classmethod TableFields(tableName) as %String [ ZenMethod ]
Given schema == table, return a list of fields concatenated by commas excluding hidden fields. Used by drag and drop.
Used to Save tableNavBar values, add MapType to the page name to distinguish the type for the page.
clientmethod adjustSizes() [ Language = javascript ]
clientmethod deleteSelectedQuery() [ Language = javascript ]
if there are selected quries, then we are deleting selected queries.
else 1) if there are selected schema.table, then asking if user wants to delete
clientmethod doAction(action) [ Language = javascript ]
This method takes care of actions that do not need schema.table name
clientmethod doActionTable(action) [ Language = javascript ]
This method takes care of actions that need schema.table name
clientmethod doAllSchemas(applyFilter) [ Language = javascript ]
This method is called to show schemas
clientmethod doDeleteAll() [ Language = javascript ]
clientmethod doDrill(drillType, schemaname, overrideFilter) [ Language = javascript ]
drillType indicate the type (1 based. Tables/Views...) if overrideFilter is 0 then do not override Filter unless it is null.
clientmethod doExecute() [ Language = javascript ]
clientmethod doFilterType() [ Language = javascript ]
user changed filter type. Show or hide procedure options.
clientmethod doHistory() [ Language = javascript ]
*** Methods for Exeucte Query ***
clientmethod doInprogress() [ Language = javascript ]
clientmethod doOpenDoc(className) [ Language = javascript ]
This method opens Documatic in a seperate window. Called by table class doc and procedure doc.
clientmethod doOpenTableMax(maxRows) [ Language = javascript ]
clientmethod doQueryBuilder() [ Language = javascript ]
clientmethod doRebuildIndex(pIndex) [ Language = javascript ]
This is the method for rebuilding a particular index
clientmethod doReferenceTo(newtable, type) [ Language = javascript ]
User clicked a ReferenceTo link.
Check the current tree to see if we can find the reference class. If yes then make it selected and we won't need to refresh tree.
Otherwise, refresh tree with the new reference class as filter.
The tree will be collapsed and we will hide groupDetails and show message to remind user to reselect item from tree.
type arguement. 0 = Tables, 1 = View, 2 = Stored procedures
clientmethod doReloadNode(listType) [ Language = javascript ]
This method reload a particular listType.
The expected behavior:
If the current list selected on the tree is equal to the listType and is expanded, then reload the list and expand.
clientmethod doSearch() [ Language = javascript ]
reload tree with new filter. when this happens we want to hide groupDetails and
show the message to remind user to select item from tree.
clientmethod doSelectRow(thisTable) [ Language = javascript ]
clientmethod doShowPlan() [ Language = javascript ]
clientmethod doStatementDetailsTo(stmthash, openInTab) [ Language = javascript ]
User clicked a StatementDetailsTo link.
clientmethod doTree(tree) [ Language = javascript ]
*** Methods for tree item text click ***
clientmethod getTable() [ Language = javascript ]
Return tree's selected index value
clientmethod historyFilterChanged(value) [ Language = javascript ]
User entered something in to the filter. Re-load the table with filter value.
clientmethod keyUp(zenEvent, flag) [ Language = javascript ]
Check if user hit [Enter].
clientmethod keyUpQueryText(tControl) [ Language = javascript ]
Overriden to add tabId and tableId to the page name to distinguish the type for the page.
Overriden to add tabId and tableId to the page name to distinguish the type for the page.
clientmethod onPopupAction(popupName, action, value) [ Language = javascript ]
This client event is fired when the a popup page launched from this page fires an action.
clientmethod onlayoutHandler(load) [ Language = javascript ]
Inherited description: This client event, if present, is fired when the page
is first loaded or whenever it is resized.
If this is called at load time, then load will be true.
If this is called at load time, then load will be true.
clientmethod onloadHandler(load) [ Language = javascript ]
Inherited description: Disable save button for EMS-managed pages.
Be sure to use this.invokeSuper('onloadHandler',arguments); when overriding.
clientmethod prepareProp(routine) [ Language = javascript ]
User clicked the Cached Query link (it used to be a routine and now it's class) after executed a query. Hide components so that we can show CQ details.
Check the current tree to see if we can find the routine. If yes then make it selected and we won't need to refresh tree.
Otherwise, refresh tree with the new routine as filter.
The tree will be collapsed and we will hide groupDetails and show message to remind user to reselect item from tree.
clientmethod selectCQ(tRoutine, tAction) [ Language = javascript ]
User clicked Exeucte or ShowPlan link from the Cached Query details box. Query Routine is passed in.
clientmethod selectHistory(tID, tAction) [ Language = javascript ]
This method processes actions for a query history item.
clientmethod selectSchema(schema) [ Language = javascript ]
clientmethod showCQ(routine) [ Language = javascript ]
clientmethod showCQTable(routine) [ Language = javascript ]
clientmethod showCatalog() [ Language = javascript ]
show catalog details for a table
clientmethod showCatalogCQ() [ Language = javascript ]
show catalog details for a cached query
clientmethod showCatalogProc() [ Language = javascript ]
show catalog details for a stored procedure
clientmethod showCatalogView() [ Language = javascript ]
show catalog details for a view
clientmethod showExpand() [ Language = javascript ]
Inherited description: Note that this arrow is the opposite of search.
clientmethod showStatement(statement) [ Language = javascript ]
clientmethod showStatementTable(statement) [ Language = javascript ]
clientmethod showStatements() [ Language = javascript ]
show statement details for a table
clientmethod statementFilterChanged(value) [ Language = javascript ]
User entered something in to the filter. Re-load the table with filter value.
clientmethod statementRefresh() [ Language = javascript ]
this method maybe called from StatementDetails page to update table
clientmethod tabChanged(tab, totalTabs) [ Language = javascript ]
user clicked a tab. hide/show result tables, and alter tab's background color.
clientmethod tableDropHandler(dragData) [ Language = javascript ]
Drop handler for model table.
clientmethod timeout() [ Language = javascript ]
This is currently used for cached queries. When user clicks the cached query name from the Execute Query tab,
we reload the tree for the cached query and starts the timer. When the timer reaches it's end it calls this method
to have the selected cached query "clicked" so that the CQ info block can be shown.
clientmethod toggleClearText(tControl) [ Language = javascript ]
show or hide the Clear image for Query Text or Filter
classmethod toggleIndexStatus(tableName As %String, indexName As %String, selectability As %Boolean) as %Status [ ZenMethod ]
clientmethod toggleOptions() [ Language = javascript ]
clientmethod toggleSearch() [ Language = javascript ]
Toggle display of search pane.
clientmethod updateParameters() [ Language = javascript ]
Update properties for Execute Query and save to server for the future.
clientmethod updateStatistics() [ Language = javascript ]
This method is fired up after onDrawContent is finished. Hide progress message and display error if exists.
clientmethod updateTreeItems() [ Language = javascript ]
Update number of tree items loaded after a tree branch is loaded.
Totals are displayed at the bottom of the the tree pane
clientmethod validateText() [ Language = javascript ]
Inherited Members
Inherited Properties
- %condition
- %import
- %includeFiles
- %page
- %resource
- Filter
- FirstFailed
- HelpAddress
- ISREADONLY
- InvalidParam
- IsEMSReadOnly
- IsEditForm
- LocatorHeader
- OnclickArray
- PID
- ParentURL
- StdTitle
- TableMaxRows
- TablePageSize
- ValidationErrorMsg
- aboutPage
- align
- aux
- backgroundTimerInterval
- cellAlign
- cellSize
- cellStyle
- cellVAlign
- children
- composite
- contactPage
- containerStyle
- cssLevel
- currSortMode
- currStep
- currViewMode
- disabled
- dragAndDrop
- dragEnabled
- dropEnabled
- enclosingClass
- enclosingStyle
- error
- groupClass
- groupStyle
- height
- hidden
- hint
- hintClass
- hintStyle
- home
- homePage
- id
- index
- label
- labelClass
- labelDisabledClass
- labelPosition
- labelStyle
- layout
- lblTitle
- limitPopups
- name
- onafterdrag
- onbeforedrag
- onclick
- ondrag
- ondrop
- onhide
- onrefresh
- onshow
- onupdate
- pageModified
- parent
- searchKey
- showLabel
- slice
- title
- tuple
- useSVG
- useSoftModals
- valign
- visible
- width
- window
- zenPersistentPopup
Inherited Methods
- %AddChild()
- %AddChildAfter()
- %AddChildBefore()
- %AddComponent()
- %AddImportedComponents()
- %AddLocatorLinks()
- %AddToSaveSet()
- %ApplyURLParms()
- %Attr()
- %BindExport()
- %ClassIsLatestVersion()
- %ClassName()
- %ConstructClone()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %DrawAutoLogout()
- %DrawClassDefinitions()
- %DrawComponentHTML()
- %DrawHTML()
- %DrawHTMLPage()
- %DrawJSStrings()
- %DrawObjectDefinitions()
- %EnclosingDivId()
- %EndBackgroundMethod()
- %EndScript()
- %Eval()
- %EvalC()
- %Extends()
- %ForceClientRender()
- %GetChildIndex()
- %GetComponent()
- %GetComponentById()
- %GetComponentByName()
- %GetEventHandlers()
- %GetHomePage()
- %GetHomeParam()
- %GetLinks()
- %GetLocatorLinks()
- %GetNavTableState()
- %GetPageName()
- %GetParameter()
- %GetProductName()
- %GetValueById()
- %GetValueByName()
- %GetXMLName()
- %IsA()
- %IsModified()
- %Link()
- %LinkCSS()
- %LinkScript()
- %MakeId()
- %New()
- %NormalizeObject()
- %ObjectModified()
- %OnAddToPageAfter()
- %OnAddToPageBefore()
- %OnBeforeCreatePage()
- %OnCreateApplication()
- %OnCreatePage()
- %OnDetermineCSSLevel()
- %OnDrawEnclosingDiv()
- %OnDrawHTMLBody()
- %OnDrawHTMLHead()
- %OnDrawHTMLMeta()
- %OnDrawObjectProperties()
- %OnGetProductName()
- %OnGetSmallMenu()
- %OnGetTitle()
- %OnMutateChildren()
- %OnObjectSynch()
- %OnPreHTTP()
- %OnSubmit()
- %OnUseSoftModals()
- %OnZENDeserialize()
- %OriginalNamespace()
- %PackageName()
- %QuoteValue()
- %QuoteValueL10N()
- %Register()
- %RemoveChild()
- %RemoveChildren()
- %RemoveComponent()
- %RemoveFromSaveSet()
- %RunBackgroundMethod()
- %Self()
- %SerializeObject()
- %SetBackgroundMethodStatus()
- %SetErrorById()
- %SetErrorByName()
- %SetModified()
- %SetValueById()
- %SetValueByName()
- %SetValuesByName()
- %StartScript()
- %ValidateObject()
- %ZENVersion()
- BuildMenu()
- CheckAllBlanks()
- CheckContextLinks()
- CheckEnterpriseManager()
- ConvertParameter()
- Decrypt()
- DoLogout()
- DrawLocator()
- DrawRibbon()
- DrawTitle()
- Encrypt()
- EscapeHTML()
- EscapeURL()
- EvalResult()
- GetCSPURL()
- GetContextLinks()
- GetDocURL()
- GetHomePage()
- GetNewURL()
- GetQuickLinks()
- HyperEventCall()
- HyperEventHead()
- Include()
- InsertHiddenField()
- InsertHiddenFields()
- IsPrivate()
- JavaInstalled()
- Link()
- OnDrawRibbon()
- OnHTTPHeader()
- OnPage()
- OnPageError()
- OnPostHTTP()
- OnPostHyperEvent()
- OnPreHTTP()
- OnPreHyperEvent()
- Page()
- QuoteJS()
- ReallyClearEscalation()
- RegisterRecent()
- RewriteURL()
- ShowError()
- StartTimer()
- StopTimer()
- ThrowError()
- UnescapeHTML()
- UnescapeURL()
- XMLDTD()
- XMLExport()
- XMLExportToStream()
- XMLExportToString()
- XMLNew()
- XMLSchema()
- XMLSchemaNamespace()
- XMLSchemaType()
- addChild()
- addChildAfter()
- addChildBefore()
- afterSave()
- afterValidate()
- cancelPopup()
- changePassword()
- childrenMutated()
- clearEscalation()
- correctIELayering()
- createComponent()
- createComponentNS()
- deleteComponent()
- disableCommandButton()
- doCancel()
- doModified()
- dragFinishHandler()
- dragHandler()
- dragNotifyHandler()
- dragStartHandler()
- dropHandler()
- dropStartHandler()
- enableCommandButton()
- endModal()
- escalateLogin()
- exposeComponent()
- findElement()
- fireOnResizeEvent()
- fireOnUnloadEvent()
- fireOnUpdateEvent()
- firePopupAction()
- getChildIndex()
- getComponent()
- getComponentById()
- getEnclosingDiv()
- getHidden()
- getHintElement()
- getLabelElement()
- getOpener()
- getPageTitle()
- getProperty()
- getSettings()
- getTitleAreaHeight()
- getType()
- goHome()
- goMenu()
- gotoNamespace()
- gotoPage()
- hideCommandButton()
- invokeSuper()
- isButtonDisabled()
- isOfType()
- launchPopupWindow()
- logout()
- makeId()
- navigate()
- onCreate()
- onDelete()
- onDisplayHandler()
- onEndModalHandler()
- onRefreshContents()
- onSerialize()
- onServerMethodCall()
- onServerMethodError()
- onServerMethodReturn()
- onStartModalHandler()
- ondisabledHandler()
- onhandleAutoLogoutWarn()
- onkeydownHandler()
- onkeyupHandler()
- onlogoutHandler()
- onoverlayHandler()
- onresizeHandler()
- onunloadHandler()
- onupdateHandler()
- popupActionHandler()
- refreshContents()
- removeChild()
- render()
- renderContents()
- renderSVG()
- resetMsg()
- searchBlur()
- searchBoxHandler()
- searchFocus()
- searchKeyDown()
- searchKeyPress()
- setComponentId()
- setConnectivityStatusMsg()
- setHidden()
- setModified()
- setOverlayMode()
- setPageTitle()
- setProperty()
- setPropertyAll()
- setSortMode()
- setSortModeHandler()
- setTraceOption()
- setViewMode()
- setViewModeHandler()
- showAbout()
- showCommandButton()
- showContact()
- showDocumentation()
- showHelp()
- showMsg()
- startModal()
- startProgressBar()
- stopProgressBar()
- switchNamespace()
- toggleSettings()
- trimSpace()
- validateRequired()