project BLF > class BUser > business logic query UserBusActivityByUserId
Description
UserBusActivityByUserId
mandatory parameters are :
UsrId, BusActivityId and BusComponentId
Parameters
| iiUsrId | integer | |
| iiCompanyId | integer | Company id |
| iiRoleId | integer | |
| iiBusComponentId | integer | BusComponent ID |
| iiBusActivityId | integer | BusActivity ID |
query condition
each Usr where
Usr.Usr_ID = iiUsrId
each UsrRole (inner-join) where
UsrRole.Usr_ID = Usr.Usr_ID AND
UsrRole.Role_ID = iiRoleId
first Role (inner-join) where
Role.Role_ID = UsrRole.Role_ID AND
each RoleResource (inner-join) where
RoleResource.Role_ID = Role.Role_ID AND
first Resources (inner-join) where
Resources.Resource_ID = RoleResource.Resource_ID AND
Resources.BusActivity_ID = iiBusActivityId
first BusActivity (inner-join) where
BusActivity.BusActivity_ID = Resources.BusActivity_ID AND
BusActivity.BusComponent_ID = iiBusComponentId
first BusComponent (inner-join) where
BusComponent.BusComponent_ID = BusActivity.BusComponent_ID AND
each UsrRoleScope (outer-join) where
UsrRoleScope.Company_Id = iiCompanyId AND
UsrRoleScope.UsrRole_ID = UsrRole.UsrRole_ID AND
query resultset tqUserBusActivityByUserId
| field name | data type | db field | description |
|---|
| tiBusActivity_ID | integer | BusActivity.BusActivity_ID | Record ID |
| tcBusActivityCode | character | BusActivity.BusActivityCode | Code |
| tiBusActivitySequence | integer | BusActivity.BusActivitySequence | Seq |
| tiBusComponent_ID | integer | Role.BusComponent_ID | Business Component |
| tcBusComponentCode | character | BusComponent.BusComponentCode | Component |
| tiRole_ID | integer | Role.Role_ID | Record ID |
| tcRoleDescription | character | Role.RoleDescription | RoleDescription |
| tiUsr_ID | integer | Usr.Usr_ID | Record ID |
| tcUsrRoleScopeValue | character | UsrRoleScope.UsrRoleScopeValue | primary key values of the main table record of the business object
Key fields are chr(2) separated. |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(Usr),rowid(UsrRole),rowid(Role),rowid(RoleResource),rowid(Resources),rowid(BusActivity),rowid(BusComponent),rowid(UsrRoleScope) |
Internal usage
BLF