Skip to main content

%BI.UserRole

persistent class %BI.UserRole extends %Library.Persistent

SQL Table Name: %BI.UserRole

Property Inventory

Properties

property Roles as %BI.Roles;
Property methods: RolesGet(), RolesGetObject(), RolesGetObjectId(), RolesGetStored(), RolesGetSwizzled(), RolesIsValid(), RolesNewObject(), RolesSet(), RolesSetObject(), RolesSetObjectId(), RolesUnSwizzle()
relationship Users as %BI.Users [ Required , Inverse = UserRole , Cardinality = parent ];
Property methods: UsersGet(), UsersGetObject(), UsersGetObjectId(), UsersGetStored(), UsersGetSwizzled(), UsersIsValid(), UsersNewObject(), UsersOnDelete(), UsersRClose(), UsersRExec(), UsersRFetch(), UsersRelate(), UsersSQLCompute(), UsersSet(), UsersSetObject(), UsersSetObjectId(), UsersUnRelate(), UsersUnSwizzle()

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

Indexes

index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()
index (Role on Roles:Exact,Users:Exact);
Index methods: RoleExists(), RolesGet(), RolesGetObject(), RolesGetObjectId(), RolesGetStored(), RolesGetSwizzled(), RolesIsValid(), RolesNewObject(), RolesSet(), RolesSetObject(), RolesSetObjectId(), RolesUnSwizzle()

Inherited Members

Inherited Methods

Storage

Storage Model: CacheStorage (%BI.UserRole)

{%%PARENT}("UserRole")(ID,"X")
=
%%CLASSNAME

Storage Model: CacheStorage (%BI.UserRole)

{%%PARENT}("UserRole")(ID)
=
Roles
FeedbackOpens in a new tab