Learning
Documentation
Community
Open Exchange
Global Masters
Home / Class Reference / ENSLIB namespace / %BI.UserRole
Private  Storage   

%BI.UserRole


persistent class %BI.UserRole extends
%Persistent

Inventory


Parameters Properties Methods Queries Indices ForeignKeys Triggers
2 2 1


Summary


Properties
Roles Users

Methods
%AddToSaveSet %AddToSyncSet %BMEBuilt %CheckConstraints
%CheckConstraintsForExtent %ClassIsLatestVersion %ClassName %ComposeOid
%ConstructClone %Delete %DeleteExtent %DeleteId
%DispatchClassMethod %DispatchGetModified %DispatchGetProperty %DispatchMethod
%DispatchSetModified %DispatchSetMultidimProperty %DispatchSetProperty %Exists
%ExistsId %Extends %GUID %GUIDSet
%GetLock %GetParameter %GetSwizzleObject %Id
%InsertBatch %IsA %IsModified %IsNull
%KillExtent %KillExtentData %LoadFromMemory %LockExtent
%LockId %New %NormalizeObject %ObjectIsNull
%ObjectModified %Oid %OnBeforeAddToSync %OnDetermineClass
%Open %OpenId %OriginalNamespace %PackageName
%PhysicalAddress %PurgeIndices %Reload %RemoveFromSaveSet
%ResolveConcurrencyConflict %RollBack %Save %SaveDirect
%SaveIndices %SerializeObject %SetModified %SortBegin
%SortEnd %SyncObjectIn %SyncTransport %UnlockExtent
%UnlockId %ValidateIndices %ValidateObject


Properties


• property Roles as %BI.Roles;
• relationship Users as %BI.Users [ Inverse = UserRole,Cardinality = parent ];

Queries


• query AllRoleUser(RoleRow As %String)
SQL Query :
SELECT ID,Users->FullName
FROM %BI.UserRole
WHERE Roles=:RoleRow

• query AllUserRole(UserRow As %String)
SQL Query :
SELECT ID,Roles
FROM %BI.UserRole
WHERE Users=:UserRow


Indices


• index (Role on Roles:Exact,Users:Exact);