project BLF > class BUserRole > business logic query UsrRoleByUsrId
Parameters
| iiUsrId | integer | |
| iiCompanyId | integer | Company id |
query condition
each UsrRole where
UsrRole.Usr_ID = iiUsrId
first Role (inner-join) where
Role.Role_ID = UsrRole.Role_ID AND
each UsrRoleCompany (outer-join) where
UsrRoleCompany.Company_Id = iiCompanyId AND
UsrRoleCompany.UsrRole_ID = UsrRole.UsrRole_ID AND
first Company (outer-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = UsrRoleCompany.Company_ID AND
query resultset tqUsrRoleByUsrId
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | UsrRoleCompany.Company_ID | Entity |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tiDomain_ID | integer | Company.Domain_ID | Domain |
| tiRole_ID | integer | Role.Role_ID | Record ID |
| tcRoleDescription | character | Role.RoleDescription | RoleDescription |
| tlRoleIsActive | logical | Role.RoleIsActive | Act |
| tcRoleName | character | Role.RoleName | Role Name |
| tiUsr_ID | integer | UsrRole.Usr_ID | User |
| tiUsrRole_ID | integer | UsrRole.UsrRole_ID | Record ID |
| tiUsrRoleCompany_ID | integer | UsrRoleCompany.UsrRoleCompany_ID | Record ID |
| tlUsrRoleIsDefaultRole | logical | UsrRole.UsrRoleIsDefaultRole | Indicates the default role per user. |
Internal usage
BLF
QadFinancials