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