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