project BLF > class BUser > business logic query GetUserRoles
Description
This query returns all active roles, linked to a user, in the order of the role sequence.
Parameters
| iiUserId | integer | |
| iiCompanyId | integer | Company id |
query condition
each Usr where
Usr.Usr_ID = iiUserId
each UsrRole (inner-join) where
UsrRole.Usr_ID = Usr.Usr_ID AND
first Role (inner-join) where
Role.Role_ID = UsrRole.Role_ID AND
Role.RoleIsActive = True
each UsrRoleCompany (outer-join) where
UsrRoleCompany.Company_Id = iiCompanyId AND
UsrRoleCompany.UsrRole_ID = UsrRole.UsrRole_ID AND
query resultset tqGetUserRoles
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | UsrRoleCompany.Company_ID | Entity |
| tiRole_ID | integer | Role.Role_ID | Record ID |
| tcRoleDescription | character | Role.RoleDescription | RoleDescription |
| tcRoleName | character | Role.RoleName | Role Name |
| tiUsr_ID | integer | Usr.Usr_ID | Record ID |
| tcUsrLogin | character | Usr.UsrLogin | Login |
| tlUsrRoleIsDefaultRole | logical | UsrRole.UsrRoleIsDefaultRole | Indicates the default role per user. |
Internal usage
QadFinancials