project BLF > class BWorkObject > business logic query WorkObjectScopeHolderByUsrRole

Description

WorkObjectScopeHolderByUsrRole; Get ScopeHolders based on the UsrID and the RoleID. Note that the UsrID is chacked against WorkObjectScopeHolder.Usr_ID and not against WorkObject.Usr_ID


Parameters


iiCompanyIdintegerCompany id
iiUsrIDintegerUsrID that has to match WorkObjectScopeHolder.Usr_ID (not WorkObject.Usr_ID)
iiRoleIDintegerRoleID of the WorkObject


query condition


  each WorkObject where
WorkObject.Company_Id = iiCompanyId AND
WorkObject.Role_ID = iiRoleID

      first BusComponent (inner-join) where
BusComponent.BusComponent_ID = WorkObject.BusComponent_ID AND

      each WorkObjectScopeHolder (inner-join) where
WorkObjectScopeHolder.WorkObject_ID = WorkObject.WorkObject_ID AND
WorkObjectScopeHolder.Usr_ID = iiUsrID


query resultset tqWorkObjectScopeHolderByUsrRole


field namedata typedb fielddescription
tiUsr_IDintegerWorkObjectScopeHolder.Usr_IDUser
tiWorkObjectScopeHolder_IDintegerWorkObjectScopeHolder.WorkObjectScopeHolder_IDRecord ID
tiCompany_IDintegerWorkObject.Company_IDEntity
tiRole_IDintegerWorkObject.Role_IDRole
tiWorkObject_IDintegerWorkObject.WorkObject_IDRecord ID
tcBusComponentCodecharacterBusComponent.BusComponentCodeComponent
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(WorkObject),rowid(BusComponent),rowid(WorkObjectScopeHolder)


Internal usage


BLF
method BUserRole.AdditionalUpdates