project BLF > class BObjectSecurity > business logic query ObjectActivities
Description
activities on object
(none returned = all allowed)
Parameters
| icObjectRef | character | |
| icBusCompCode | character | |
query condition
each ObjectSecurity where
ObjectSecurity.ObjectSecurityObjectRef = icObjectRef
first RoleResource (inner-join) where
RoleResource.RoleResource_ID = ObjectSecurity.RoleResource_ID AND
first Resources (inner-join) where
Resources.Resource_ID = RoleResource.Resource_ID AND
first BusActivity (inner-join) where
BusActivity.BusActivity_ID = Resources.BusActivity_ID AND
first BusComponent (inner-join) where
BusComponent.BusComponent_ID = BusActivity.BusComponent_ID AND
BusComponent.BusComponentCode = icBusCompCode
first UsrRole (inner-join) where
UsrRole.UsrRole_ID = ObjectSecurity.UsrRole_ID AND
first Usr (inner-join) where
Usr.Usr_ID = UsrRole.Usr_ID AND
query resultset tqObjectActivities
| field name | data type | db field | description |
|---|
| tiBusActivity_ID | integer | BusActivity.BusActivity_ID | Record ID |
| tcBusActivityCode | character | BusActivity.BusActivityCode | Code |
| tcBusComponentCode | character | BusComponent.BusComponentCode | Component |
| tiObjectSecurity_ID | integer | ObjectSecurity.ObjectSecurity_ID | Record ID |
| tiUsr_ID | integer | UsrRole.Usr_ID | User |
| tcUsrLogin | character | Usr.UsrLogin | Login |
| tcUsrName | character | Usr.UsrName | User Name |
| tiRole_ID | integer | RoleResource.Role_ID | Role |
Internal usage
BLF