project BLF > class BWorkObject > business logic query WorkObjectByUsrForWFAll
Parameters
iiCompanyId | integer | Company id |
iiUsrId | integer | |
query condition
each WorkObject where
WorkObject.Company_Id = iiCompanyId AND
WorkObject.Role_ID = 0 and
WorkObject.Usr_ID = 0
first BusActivity (inner-join) where
BusActivity.BusActivity_ID = WorkObject.BusActivity_ID AND
each Resources (inner-join) where
Resources.BusActivity_ID = BusActivity.BusActivity_ID AND
each RoleResource (inner-join) where
RoleResource.Resource_ID = Resources.Resource_ID AND
first Role (inner-join) where
Role.Role_ID = RoleResource.Role_ID AND
each UsrRole (inner-join) where
UsrRole.Role_ID = Role.Role_ID AND
UsrRole.Usr_ID = iiUsrId
each fcInstance (outer-join) where
fcInstance.Instance_ID = (WorkObject.WorkObjectInternal_ID * -1) AND
fcInstance.InstanceIsInUse = true
query resultset tqWorkObjectByUsrForWFAll
field name | data type | db field | description |
tiBusActivity_ID | integer | WorkObject.BusActivity_ID | Business Activity |
tiBusComponent_ID | integer | WorkObject.BusComponent_ID | Business Component |
tiInstance_ID | integer | fcInstance.Instance_ID | Record ID |
tlInstanceIsInUse | logical | fcInstance.InstanceIsInUse | set to true when the instance is loaded in memory for editing |
ttLastModifiedDate | date | WorkObject.LastModifiedDate | Last Modified Date |
tiLastModifiedTime | integer | WorkObject.LastModifiedTime | Last Modified Time |
tiUsr_ID | integer | WorkObject.Usr_ID | User |
tiWorkObject_ID | integer | WorkObject.WorkObject_ID | Record ID |
tcWorkObjectInstruction | character | WorkObject.WorkObjectInstruction | Instructions |
tiWorkObjectInternal_ID | integer | WorkObject.WorkObjectInternal_ID | Identification of the business object (= identity value of the main table record) |
tlWorkObjectIsExternalCtrl | logical | WorkObject.WorkObjectIsExternalCtrl | Workflow is controlled by an external workflow system. |
tlWorkObjectIsInternalCtrl | logical | WorkObject.WorkObjectIsInternalCtrl | Workflow is controlled by the internal ad-hoc workflow system. |
tiWorkObjectRole_ID | integer | WorkObject.Role_ID | Role |
Internal usage
BLF