project BLF > class BRole > business logic query RoleResourceByResUserComp


Parameters


icResourceIdcharacter
iiCompanyIdintegerCompany id
icUserIdcharacter


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 namedata typedb fielddescription
tiCompany_IDintegerUsrRoleCompany.Company_IDEntity
tiResource_IDintegerRoleResource.Resource_IDResource
tiUsr_IDintegerUsrRoleCompany.Usr_IDUser


Internal usage


BLF
method business.ApiActivitiesAreAllowed
method business.apiActivityIsAllowed