Skip to main content


class %CSP.UI.Component.SQLTables extends %ZEN.Component.component, %CSP.UI.Component.SelectBoxUtils

Component for editing SQL Tables, Views, Procedures, and ML Configurations on the User and Role edit pages

Property Inventory

Method Inventory


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()


method %DrawHTML()
The %DrawHTML method draws the initial HTML for this component.
classmethod BuildLine(tVal As %String, nPrivilegesLen As %Integer)
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

Inherited Methods

FeedbackOpens in a new tab