Class %CSP.UI.Component.SQLTables

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

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
	14	13

Summary

Properties
%condition	%import	%includeFiles	%page
%resource	PID	align	aux
avaList	composite	containerStyle	dragEnabled
dropEnabled	enclosingClass	enclosingStyle	error
height	hidden	hint	hintClass
hintStyle	id	includeSystem	index
label	labelClass	labelDisabledClass	labelStyle
name	namespace	nsDisplayList	nsValueList
onafterdrag	onbeforedrag	ondrag	ondrop
onhide	onrefresh	onshow	onupdate
pageType	parent	readOnly	resultsPage
resultsPageSize	selList	showLabel	showSystemBox
slice	tab	title	tuple
type	usePaging	valign	visible
width	window

Methods
%AddToSaveSet	%Attr	%BindExport	%ClassIsLatestVersion
%ClassName	%ConstructClone	%DispatchClassMethod	%DispatchGetModified
%DispatchGetProperty	%DispatchMethod	%DispatchSetModified	%DispatchSetMultidimProperty
%DispatchSetProperty	%DrawComponentHTML	%DrawHTML	%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	BuildLine	DrawArrows	DrawArrowsOld
DrawAvailableList	DrawSelectList	DrawUpArrowsOld	RevokeRow
SetIncludeSystem	XMLDTD	XMLExport	XMLExportToStream
XMLExportToString	XMLNew	XMLSchema	XMLSchemaNamespace
XMLSchemaType	changeNS	changeSysItems	clearList
doLaunchColumns	doLaunchMLConfigurations	doLaunchSchemas	doRevokeObj
doSelectBoxMove	doSelectBoxMoveAll	doSelectBoxMoveItem	doSelectBoxMoveList
dragFinishHandler	dragHandler	dragNotifyHandler	dragStartHandler
dropHandler	dropStartHandler	exposeComponent	findElement
fireOnUpdateEvent	getEnclosingDiv	getHidden	getHintElement
getLabelElement	getProperty	getSelList	getSettings
getType	gotoPage	invokeSuper	isOfType
makeId	nextPage	onCreate	onDelete
onDisplayHandler	onEndModalHandler	onPopupAction	onRefreshContents
onSerialize	onStartModalHandler	onloadHandler	onunloadHandler
onupdateHandler	prevPage	refreshContents	render
renderContents	renderSVG	setHidden	setOverlayMode
setProperty	startProgressBar	stopProgressBar

Properties

• property PID as %ZEN.Datatype.string(ZENEXPRESSION=1);

Name of the User/Role being edited

• property includeSystem as %ZEN.Datatype.integer [ InitialExpression = 0 ];

• property namespace as %ZEN.Datatype.string;

• property nsDisplayList as %ZEN.Datatype.string;

• property nsValueList as %ZEN.Datatype.string;

• property pageType as %ZEN.Datatype.string(VALUELIST=",Users,Roles");

• property readOnly as %ZEN.Datatype.boolean(ZENEXPRESSION=1) [ InitialExpression = 0 ];

If true, tables are for display only

• 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 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 showSystemBox as %ZEN.Datatype.boolean [ InitialExpression = 0 ];

• property tab as %ZEN.Datatype.integer;

• property type as %ZEN.Datatype.string;

• property usePaging as %ZEN.Datatype.boolean(ZENEXPRESSION=1) [ InitialExpression = 1 ];

Allow this component to page its results.

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 ]

• method changeNS(sel) [ Language = javascript ]

• method changeSysItems(chbox) [ Language = javascript ]

• method doLaunchColumns(PID, objName) [ Language = javascript ]

• method doLaunchMLConfigurations(PID, objName, objPriv) [ Language = javascript ]

• method doLaunchSchemas(PID, objName, objPriv) [ Language = javascript ]

• method doRevokeObj(PID, tblname, grantedby) [ Language = javascript ]

• method 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.

• method nextPage() [ Language = javascript ]

Navigate to the next page of results

• method prevPage() [ Language = javascript ]

Navigate to the previous page of results

Class Reference IRIS for UNIX 2024.1.2
Documentation Search