project BLF > class BRole > business logic query RoleBusActivityByActivityRole

Description

Find RoleBusActivity based on Activity-ID and Role-ID (or Code)


Parameters


iiBusActivityIDintegerBus Activity ID
iiRoleIDintegerRoleId
icRoleNamecharacterRole Name


query condition


  each RoleResource where
RoleResource.Role_ID = iiRoleID

      first Resources (inner-join) where
Resources.Resource_ID = RoleResource.Resource_ID AND
Resources.BusActivity_ID = iiBusActivityID

      first Role (inner-join) where
Role.Role_ID = RoleResource.Role_ID AND
Role.RoleName = icRoleName


query resultset tqRoleBusActivityByActivityRole


field namedata typedb fielddescription
tiBusActivity_IDintegerResources.BusActivity_IDBusiness Activity
tiResource_IDintegerRoleResource.Resource_IDResource
tcResourceURIcharacterResources.ResourceURIUniversal Resource Identification
tiRole_IDintegerRoleResource.Role_IDRole
tcRoleNamecharacterRole.RoleNameRole Name
tiRoleResource_IDintegerRoleResource.RoleResource_IDRecord ID
tiSODcategory_IDintegerResources.SODcategory_IDSegregation of Duties Category reference


Internal usage


BLF
method BWorkObject.ValidateComponent