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