project BLF > class BFieldSecurity > business logic query FieldSecurityForCompActivity


Parameters


icActivityCodecharacter
icBusCompNamecharacter
iiUsrIDintegercurrent 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 namedata typedb fielddescription
tcBusActivityCodecharacterBusActivity.BusActivityCodeCode
tcBusComponentCodecharacterBusComponent.BusComponentCodeComponent
tcFieldSecurityBusFieldNamecharacterFieldSecurity.FieldSecurityBusFieldNameBusiness Field Name
tlFieldSecurityIsHiddenlogicalFieldSecurity.FieldSecurityIsHiddenHidden
tlFieldSecurityIsUpdateablelogicalFieldSecurity.FieldSecurityIsUpdateableUpdatable
tiRole_IDintegerFieldSecurity.Role_IDRole


Internal usage


BLF
method database.GetBusinessFields
method database.ValidateFieldSecurity
method BFieldSecurity.GetBusFieldsNoFS