persistent class %BI.UserRole
extends %Persistent
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
index (Role on Roles:Exact,Users:Exact);