business logic query WorkObjectByUsrForWFAll

Parameters

iiCompanyId	integer	Company id
iiUsrId	integer

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

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

BLF