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