project BLF > class BRole > business logic query RoleResourceByResUserComp
Parameters
| icResourceId | character | |
| iiCompanyId | integer | Company id |
| icUserId | character | |
query condition
each RoleResource where
RoleResource.Resource_ID = icResourceId
first Role (inner-join) where
Role.Role_ID = RoleResource.Role_ID AND
each UsrRoleCompany (inner-join) where
UsrRoleCompany.Role_ID = Role.Role_ID AND
UsrRoleCompany.Company_ID = iiCompanyId AND
UsrRoleCompany.Usr_ID = icUserId
query resultset tqRoleResourceByResUserComp
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | UsrRoleCompany.Company_ID | Entity |
| tiResource_ID | integer | RoleResource.Resource_ID | Resource |
| tiUsr_ID | integer | UsrRoleCompany.Usr_ID | User |
Internal usage
BLF