business logic query WorkObjectByUsrForWFRole

Parameters

iiUsrId	integer
iiCompanyId	integer	Company id

each UsrRole where

UsrRole.Usr_ID = iiUsrId

first Role (inner-join) where

Role.Role_ID = UsrRole.Role_ID AND

each WorkObject (inner-join) where

WorkObject.Company_Id = iiCompanyId AND
WorkObject.Role_ID = Role.Role_ID AND

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
tiRole_ID	integer	WorkObject.Role_ID	Role
tiUsr_ID	integer	UsrRole.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.
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(UsrRole),rowid(Role),rowid(WorkObject),rowid(fcInstance)

BLF