project BLF > class BUserRole > business logic query UsrRoleCompanyByUsrRoleCompDom
Parameters
| iiCompanyId | integer | Company id |
| icUsrLogin | character | |
| icRoleName | character | |
| icCompanyCode | character | |
| icDomainCode | character | |
| iiUserId | integer | |
| iiRoleId | integer | |
| iiDomainId | integer | |
query condition
each UsrRoleCompany where
UsrRoleCompany.Company_Id = iiCompanyId AND
UsrRoleCompany.Domain_ID = iiDomainId AND
UsrRoleCompany.Role_ID = iiRoleId AND
UsrRoleCompany.Usr_ID = iiUserId
first Role (inner-join) where
Role.Role_ID = UsrRoleCompany.Role_ID AND
Role.RoleName = icRoleName
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = UsrRoleCompany.Company_ID AND
Company.CompanyCode = icCompanyCode
first Domains (inner-join) where
Domains.Domain_ID = UsrRoleCompany.Domain_ID AND
Domains.DomainCode = icDomainCode
first Usr (inner-join) where
Usr.Usr_ID = UsrRoleCompany.Usr_ID AND
Usr.UsrLogin = icUsrLogin
first UsrRole (inner-join) where
UsrRole.UsrRole_ID = UsrRoleCompany.UsrRole_ID AND
query resultset tqUsrRoleCompanyByUsrRoleCompDom
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | UsrRoleCompany.Company_ID | Entity |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tcRoleName | character | Role.RoleName | Role Name |
| tiUsr_ID | integer | UsrRoleCompany.Usr_ID | User |
| tcUsrLogin | character | Usr.UsrLogin | Login |
| tlUsrRoleIsDefaultRole | logical | UsrRole.UsrRoleIsDefaultRole | Indicates the default role per user. |
Internal usage
BLF