project BLF > class BFieldSecurity > business logic query FieldSecurityForCompActivity
Parameters
| icActivityCode | character | |
| icBusCompName | character | |
| iiUsrID | integer | current user |
query condition
each FieldSecurity where
first BusActivity (inner-join) where
BusActivity.BusActivity_ID = FieldSecurity.BusActivity_ID AND
BusActivity.BusActivityCode = icActivityCode
each Resources (inner-join) where
Resources.BusActivity_ID = BusActivity.BusActivity_ID AND
each RoleResource (inner-join) where
RoleResource.Resource_ID = Resources.Resource_ID AND
RoleResource.Role_ID = FieldSecurity1.Role_ID
first Role (inner-join) where
Role.Role_ID = RoleResource.Role_ID AND
each UsrRole (inner-join) where
UsrRole.Role_ID = Role.Role_ID AND
UsrRole.Usr_ID = iiUsrID
first BusComponent (inner-join) where
BusComponent.BusComponent_ID = FieldSecurity.BusComponent_ID AND
BusComponent.BusComponentCode = icBusCompName
query resultset tqFieldSecurityForCompActivity
| field name | data type | db field | description |
|---|
| tcBusActivityCode | character | BusActivity.BusActivityCode | Code |
| tcBusComponentCode | character | BusComponent.BusComponentCode | Component |
| tcFieldSecurityBusFieldName | character | FieldSecurity.FieldSecurityBusFieldName | Business Field Name |
| tlFieldSecurityIsHidden | logical | FieldSecurity.FieldSecurityIsHidden | Hidden |
| tlFieldSecurityIsUpdateable | logical | FieldSecurity.FieldSecurityIsUpdateable | Updatable |
| tiRole_ID | integer | FieldSecurity.Role_ID | Role |
Internal usage
BLF