project BLF > class BWorkObject > business logic query WorkObjectByUsrForWFAll


Parameters


iiCompanyIdintegerCompany id
iiUsrIdinteger


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 namedata typedb fielddescription
tiBusActivity_IDintegerWorkObject.BusActivity_IDBusiness Activity
tiBusComponent_IDintegerWorkObject.BusComponent_IDBusiness Component
tiInstance_IDintegerfcInstance.Instance_IDRecord ID
tlInstanceIsInUselogicalfcInstance.InstanceIsInUseset to true when the instance is loaded in memory for editing
ttLastModifiedDatedateWorkObject.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerWorkObject.LastModifiedTimeLast Modified Time
tiUsr_IDintegerWorkObject.Usr_IDUser
tiWorkObject_IDintegerWorkObject.WorkObject_IDRecord ID
tcWorkObjectInstructioncharacterWorkObject.WorkObjectInstructionInstructions
tiWorkObjectInternal_IDintegerWorkObject.WorkObjectInternal_IDIdentification of the business object
(= identity value of the main table record)
tlWorkObjectIsExternalCtrllogicalWorkObject.WorkObjectIsExternalCtrlWorkflow is controlled by an external workflow system.
tlWorkObjectIsInternalCtrllogicalWorkObject.WorkObjectIsInternalCtrlWorkflow is controlled by the internal ad-hoc workflow system.
tiWorkObjectRole_IDintegerWorkObject.Role_IDRole


Internal usage


BLF
method Session.GetWorkAssistantObjects