persistent class %BI.Roles
extends %Persistent
query AllRoles()
SQL Query
:
SELECT ID,Description,ParentRole,LicMax,MinDrl FROM %BI.Roles ORDER BY Description
query RolesByPar(id)
SQL Query
:
SELECT ID,Description,ParentRole,LicMax,MinDrl FROM %BI.Roles
WHERE (ParentRole = :id)
index (Desc on Description) [Unique];