project BLF > class BControlProperty > business logic query LookupControlProperties


Parameters


iiBusActivityIDinteger
iiLayerTypeinteger
icBusComponentCodecharacter
icBusComponentLabelcharacter
icBusActivityCodecharacter
icBusActivityLabelcharacter
icFormcharacter


query condition


  each ControlProperty where
ControlProperty.BusActivity_ID = iiBusActivityID AND
ControlProperty.ControlPropertyLayerType = iiLayerType AND
ControlProperty.ControlPropertyWindow = icForm

      first BusActivity (inner-join) where
BusActivity.BusActivity_ID = ControlProperty.BusActivity_ID AND
BusActivity.BusActivityCode matches icBusActivityCode AND
BusActivity.BusActivityLabel matches icBusActivityLabel

          first BusComponent (inner-join) where
BusComponent.BusComponent_ID = BusActivity.BusComponent_ID AND
BusComponent.BusComponentCode matches icBusComponentCode AND
BusComponent.BusComponentLabel matches icBusComponentLabel


query resultset tqLookupControlProperties


field namedata typedb fielddescription
tiBusActivity_IDintegerBusActivity.BusActivity_IDRecord ID
tcBusActivityCodecharacterBusActivity.BusActivityCodeCode
tcBusActivityLabelcharacterBusActivity.BusActivityLabelActivity
tiBusComponent_IDintegerBusComponent.BusComponent_IDBusComponent_ID
tcBusComponentCodecharacterBusComponent.BusComponentCodeComponent
tcBusComponentLabelcharacterBusComponent.BusComponentLabelLabel
api annotation:test annotation for BusComponentLabel
tcControlPropertyControlcharacterControlProperty.ControlPropertyControlfully qualified control name
tiControlPropertyLayerTypeintegerControlProperty.ControlPropertyLayerTypescope of the customization
possible values:
1 (user level)
2 (role level)
3 (system level)
tiControlPropertyLayerValueintegerControlProperty.ControlPropertyLayerValueuserID when customized on user level
roleID when customized on role level
zero when customized on system level
tcControlPropertyNamecharacterControlProperty.ControlPropertyNameproperty name
tcControlPropertyWindowcharacterControlProperty.ControlPropertyWindowuser interface name


Internal usage


BLF
method BControlProperty.GetCustomisedLevels