project BLF > class BRole > business logic query WorkQueueFieldsByRoleCompAct
Description
GetWorkQueueFields
Parameters
| icBusAcitivityCode | character | BusAcitivityCode; AcitivityCode |
| icBusComponentCode | character | BusComponentCode; BusinessComponent |
| iiRoleID | integer | RoleId |
query condition
each RoleResource where
RoleResource.Role_ID = iiRoleID
first Resources (inner-join) where
Resources.Resource_ID = RoleResource.Resource_ID AND
first BusActivity (inner-join) where
BusActivity.BusActivity_ID = Resources.BusActivity_ID AND
BusActivity.BusActivityCode = icBusAcitivityCode
first BusComponent (inner-join) where
BusComponent.BusComponent_ID = BusActivity.BusComponent_ID AND
BusComponent.BusComponentCode = icBusComponentCode
each WorkQueue (inner-join) where
WorkQueue.RoleResource_ID = RoleResource.RoleResource_ID AND
each WorkQueueField (inner-join) where
WorkQueueField.WorkQueue_ID = WorkQueue.WorkQueue_ID AND
query resultset tqWorkQueueFieldsByRoleCompAct
| field name | data type | db field | description |
|---|
| tcBusActivityCode | character | BusActivity.BusActivityCode | Code |
| tcBusComponentCode | character | BusComponent.BusComponentCode | Component |
| tcBusinessField | character | WorkQueueField.BusinessField | Business Field |
| tiRole_ID | integer | RoleResource.Role_ID | Role |
| tiWorkQueue_ID | integer | WorkQueue.WorkQueue_ID | Record ID |
| tcWorkQueueDescription | character | WorkQueue.WorkQueueDescription | Description |
Internal usage
BLF