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
iiCompanyId | integer | Company id |
iiUsrID | integer | UsrID that has to match WorkObjectScopeHolder.Usr_ID (not WorkObject.Usr_ID) |
iiRoleID | integer | RoleID 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 name | data type | db field | description |
tiUsr_ID | integer | WorkObjectScopeHolder.Usr_ID | User |
tiWorkObjectScopeHolder_ID | integer | WorkObjectScopeHolder.WorkObjectScopeHolder_ID | Record ID |
tiCompany_ID | integer | WorkObject.Company_ID | Entity |
tiRole_ID | integer | WorkObject.Role_ID | Role |
tiWorkObject_ID | integer | WorkObject.WorkObject_ID | Record ID |
tcBusComponentCode | character | BusComponent.BusComponentCode | Component |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(WorkObject),rowid(BusComponent),rowid(WorkObjectScopeHolder) |
Internal usage
BLF