project BLF > class BBusinessComponent > business logic query BusActivityByCompActCode

Description

BusActivityByCompActCode: query on table BusComponent (with join to BusAct) with parameters on busAct.busActCode and busComp.BusCompCode.

KEEP THIS QUERY AS SIMPLE AS POSSIBLE AS THIS GETS CALLED FROM BCONTROLPROPERTY AND AS THIS IS USED SEVERAL TIMES AS FORM GETS OPEND OR CLOSED.


Parameters


icBusActitvityCodecharacterBusActitvityCode
icBusComponentCodecharacterBusComponentCode


query condition


  each BusComponent where
BusComponent.BusComponentCode = icBusComponentCode

      each BusActivity (inner-join) where
BusActivity.BusComponent_ID = BusComponent.BusComponent_ID AND
BusActivity.BusActivityCode = icBusActitvityCode


query resultset tqBusActivityByCompActCode


field namedata typedb fielddescription
tiBusActivity_IDintegerBusActivity.BusActivity_IDRecord ID
tcBusActivityCodecharacterBusActivity.BusActivityCodeCode
tiBusComponent_IDintegerBusComponent.BusComponent_IDBusComponent_ID
tcBusComponentCodecharacterBusComponent.BusComponentCodeComponent


Internal usage


BLF
method BControlProperty.ApiReadCustomizationV01
method BControlProperty.DataLoadByWindowActivity
method BControlProperty.DeleteControlProperty
method BReportVariant.apiExportCustomization