project BLF > class BUserRole > business logic query UsrRoleDomainByIds
Parameters
| iiDomainId | integer | |
| iiCompanyId | integer | Company id |
| iiUsrRoleId | integer | |
query condition
each UsrRoleDomain where
UsrRoleDomain.Domain_ID = iiDomainId And
UsrRoleDomain.UsrRole_ID = iiUsrRoleId
first UsrRole (inner-join) where
UsrRole.UsrRole_ID = UsrRoleDomain.UsrRole_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 tqUsrRoleDomainByIds
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | UsrRoleCompany.Company_ID | Entity |
| tiCompDomainId | integer | Company.Domain_ID | Domain |
| tiDomain_ID | integer | UsrRoleDomain.Domain_ID | Domain |
| tiUsrRole_ID | integer | UsrRoleDomain.UsrRole_ID | User Role |
Internal usage
BLF