%CSP.UI.Component.SQLTables
class %CSP.UI.Component.SQLTables extends %ZEN.Component.component, %CSP.UI.Component.SelectBoxUtils
Component for editing SQL Tables, Views, Procedures, ML Configurations, and Foreign Servers on the User and Role edit pagesProperty Inventory
- PID
- includeSystem
- namespace
- nsDisplayList
- nsValueList
- pageType
- readOnly
- resultsPage
- resultsPageSize
- showSystemBox
- tab
- type
- usePaging
Method Inventory
- %DrawHTML()
- BuildLine()
- RevokeRow()
- SetIncludeSystem()
- changeNS()
- changeSysItems()
- doLaunchColumns()
- doLaunchMLConfigurations()
- doLaunchSchemas()
- doRevokeObj()
- gotoPage()
- nextPage()
- prevPage()
Properties
property PID as %ZEN.Datatype.string (ZENEXPRESSION = 1);
Name of the User/Role being edited
Property methods: PIDDisplayToLogical(), PIDGet(), PIDIsValid(), PIDLogicalToDisplay(), PIDLogicalToOdbc(), PIDNormalize(), PIDSet()
property includeSystem as %ZEN.Datatype.integer [ InitialExpression = 0 ];
Property methods: includeSystemDisplayToLogical(), includeSystemGet(), includeSystemIsValid(), includeSystemLogicalToDisplay(), includeSystemLogicalToOdbc(), includeSystemNormalize(), includeSystemSet()
property namespace as %ZEN.Datatype.string;
Property methods: namespaceDisplayToLogical(), namespaceGet(), namespaceIsValid(), namespaceLogicalToDisplay(), namespaceLogicalToOdbc(), namespaceNormalize(), namespaceSet()
property nsDisplayList as %ZEN.Datatype.string;
Property methods: nsDisplayListDisplayToLogical(), nsDisplayListGet(), nsDisplayListIsValid(), nsDisplayListLogicalToDisplay(), nsDisplayListLogicalToOdbc(), nsDisplayListNormalize(), nsDisplayListSet()
property nsValueList as %ZEN.Datatype.string;
Property methods: nsValueListDisplayToLogical(), nsValueListGet(), nsValueListIsValid(), nsValueListLogicalToDisplay(), nsValueListLogicalToOdbc(), nsValueListNormalize(), nsValueListSet()
property pageType as %ZEN.Datatype.string (VALUELIST = ",Users,Roles");
Property methods: pageTypeDisplayToLogical(), pageTypeGet(), pageTypeIsValid(), pageTypeLogicalToDisplay(), pageTypeLogicalToOdbc(), pageTypeNormalize(), pageTypeSet()
property readOnly as %ZEN.Datatype.boolean (ZENEXPRESSION = 1) [ InitialExpression = 0 ];
If true, tables are for display only
Property methods: readOnlyDisplayToLogical(), readOnlyGet(), readOnlyIsValid(), readOnlyLogicalToDisplay(), readOnlyLogicalToOdbc(), readOnlyLogicalToXSD(), readOnlyNormalize(), readOnlySet(), readOnlyXSDToLogical()
property resultsPage as %ZEN.Datatype.integer (XMLPROJECTION = "none") [ InitialExpression = 1 ];
The current page of results being displayed. If usePaging=0 this setting will be ignored.
Property methods: resultsPageDisplayToLogical(), resultsPageGet(), resultsPageIsValid(), resultsPageLogicalToDisplay(), resultsPageLogicalToOdbc(), resultsPageNormalize(), resultsPageSet()
property resultsPageSize as %ZEN.Datatype.integer [ InitialExpression = 100 ];
The desired number of tables to display per results page. If usePaging=0 this setting will be ignored.
Property methods: resultsPageSizeDisplayToLogical(), resultsPageSizeGet(), resultsPageSizeIsValid(), resultsPageSizeLogicalToDisplay(), resultsPageSizeLogicalToOdbc(), resultsPageSizeNormalize(), resultsPageSizeSet()
property showSystemBox as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
Property methods: showSystemBoxDisplayToLogical(), showSystemBoxGet(), showSystemBoxIsValid(), showSystemBoxLogicalToDisplay(), showSystemBoxLogicalToOdbc(), showSystemBoxLogicalToXSD(), showSystemBoxNormalize(), showSystemBoxSet(), showSystemBoxXSDToLogical()
property tab as %ZEN.Datatype.integer;
Property methods: tabDisplayToLogical(), tabGet(), tabIsValid(), tabLogicalToDisplay(), tabLogicalToOdbc(), tabNormalize(), tabSet()
property type as %ZEN.Datatype.string;
Property methods: typeDisplayToLogical(), typeGet(), typeIsValid(), typeLogicalToDisplay(), typeLogicalToOdbc(), typeNormalize(), typeSet()
property usePaging as %ZEN.Datatype.boolean (ZENEXPRESSION = 1) [ InitialExpression = 1 ];
Allow this component to page its results.
Property methods: usePagingDisplayToLogical(), usePagingGet(), usePagingIsValid(), usePagingLogicalToDisplay(), usePagingLogicalToOdbc(), usePagingLogicalToXSD(), usePagingNormalize(), usePagingSet(), usePagingXSDToLogical()
Methods
method %DrawHTML()
The %DrawHTML method draws the initial HTML for this component.
classmethod RevokeRow(NAMESPACE, Grantee, cbState, sActs, tab, sType, GrantedBy) as %String [ ZenMethod ]
classmethod SetIncludeSystem(newVal As %Integer) [ ZenMethod ]
clientmethod changeNS(sel) [ Language = javascript ]
clientmethod changeSysItems(chbox) [ Language = javascript ]
clientmethod doLaunchColumns(PID, objName) [ Language = javascript ]
clientmethod doLaunchMLConfigurations(PID, objName, objPriv) [ Language = javascript ]
clientmethod doLaunchSchemas(PID, objName, objPriv) [ Language = javascript ]
clientmethod doRevokeObj(PID, tblname, grantedby) [ Language = javascript ]
clientmethod gotoPage(pageNo) [ Language = javascript ]
Navigate to a requested page in a multi-page resultset. If the requested page is out of the actual page
range, it will automatically be reset to reuqest the first or lastreal page.
clientmethod nextPage() [ Language = javascript ]
Navigate to the next page of results
clientmethod prevPage() [ Language = javascript ]
Navigate to the previous page of results
Inherited Members
Inherited Properties
- %condition
- %import
- %includeFiles
- %page
- %resource
- align
- aux
- avaList
- composite
- containerStyle
- dragEnabled
- dropEnabled
- enclosingClass
- enclosingStyle
- error
- height
- hidden
- hint
- hintClass
- hintStyle
- id
- index
- label
- labelClass
- labelDisabledClass
- labelStyle
- name
- onafterdrag
- onbeforedrag
- ondrag
- ondrop
- onhide
- onrefresh
- onshow
- onupdate
- parent
- selList
- showLabel
- slice
- title
- tuple
- valign
- visible
- width
- window
Inherited Methods
- %AddToSaveSet()
- %Attr()
- %BindExport()
- %ClassIsLatestVersion()
- %ClassName()
- %ConstructClone()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %DrawComponentHTML()
- %DrawJSStrings()
- %EnclosingDivId()
- %Eval()
- %EvalC()
- %Extends()
- %ForceClientRender()
- %GetEventHandlers()
- %GetParameter()
- %GetXMLName()
- %IsA()
- %IsModified()
- %MakeId()
- %New()
- %NormalizeObject()
- %ObjectModified()
- %OnAddToPageAfter()
- %OnAddToPageBefore()
- %OnDrawEnclosingDiv()
- %OnDrawObjectProperties()
- %OnObjectSynch()
- %OnZENDeserialize()
- %OriginalNamespace()
- %PackageName()
- %QuoteValue()
- %QuoteValueL10N()
- %RemoveFromSaveSet()
- %Self()
- %SerializeObject()
- %SetModified()
- %ValidateObject()
- DrawArrows()
- DrawArrowsOld()
- DrawAvailableList()
- DrawSelectList()
- DrawUpArrowsOld()
- XMLDTD()
- XMLExport()
- XMLExportToStream()
- XMLExportToString()
- XMLNew()
- XMLSchema()
- XMLSchemaNamespace()
- XMLSchemaType()
- clearList()
- doSelectBoxMove()
- doSelectBoxMoveAll()
- doSelectBoxMoveItem()
- doSelectBoxMoveList()
- dragFinishHandler()
- dragHandler()
- dragNotifyHandler()
- dragStartHandler()
- dropHandler()
- dropStartHandler()
- exposeComponent()
- findElement()
- fireOnUpdateEvent()
- getEnclosingDiv()
- getHidden()
- getHintElement()
- getLabelElement()
- getProperty()
- getSelList()
- getSettings()
- getType()
- invokeSuper()
- isOfType()
- makeId()
- onCreate()
- onDelete()
- onDisplayHandler()
- onEndModalHandler()
- onPopupAction()
- onRefreshContents()
- onSerialize()
- onStartModalHandler()
- onloadHandler()
- onunloadHandler()
- onupdateHandler()
- refreshContents()
- render()
- renderContents()
- renderSVG()
- setHidden()
- setOverlayMode()
- setProperty()
- startProgressBar()
- stopProgressBar()