This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

%CSP.UI.Component.SQLTables

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

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

Property Inventory (Including Private)

Method Inventory (Including Private)

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

Methods

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 doLaunchSchemas(PID, objName, objPriv) [ Language = javascript ]
clientmethod doRevokeObj(PID, tblname, grantedby) [ Language = javascript ]

Inherited Members

Inherited Properties (Including Private)

Inherited Methods (Including Private)

Feedback