project BLF > class BBusinessComponent > business logic query BusActivityByLabeslCodesIDs

Description

BusActivityByLabeslCodesIDs; returns information about the businessactivities based on Label, ID and Code of the business-component and the Label, ID and Code of the business-activity


Parameters


iiBusComponentIDintegerBusComponentID
icBusComponentCodecharacter
icBusComponentLabelcharacterBusComponentLabel
iiBusActivityIDintegerBusActivity-id
icBusActivityCodecharacterBusActivityCode
icBusActivityLabelcharacterBusActivityLabel


query condition


  each BusComponent where
BusComponent.BusComponent_ID = iiBusComponentID AND
BusComponent.BusComponentCode matches icBusComponentCode AND
BusComponent.BusComponentLabel matches icBusComponentLabel

      each BusActivity (inner-join) where
BusActivity.BusComponent_ID = BusComponent.BusComponent_ID AND
BusActivity.BusActivity_ID = iiBusActivityID AND
BusActivity.BusActivityCode matches icBusActivityCode AND
BusActivity.BusActivityLabel matches icBusActivityLabel


query resultset tqBusActivityByLabeslCodesIDs


field namedata typedb fielddescription
tiBusActivity_IDintegerBusActivity.BusActivity_IDRecord ID
tcBusActivityCodecharacterBusActivity.BusActivityCodeCode
tlBusActivityIsDefaultlogicalBusActivity.BusActivityIsDefaultDefault
tcBusActivityLabelcharacterBusActivity.BusActivityLabelActivity
tiBusComponent_IDintegerBusComponent.BusComponent_IDBusComponent_ID
tcBusComponentCodecharacterBusComponent.BusComponentCodeComponent
tcBusComponentLabelcharacterBusComponent.BusComponentLabelLabel
api annotation:test annotation for BusComponentLabel


Internal usage


BLF
method BBusinessComponent.ApiSynchroniseDefaultActivities
method BControlProperty.GetCustomisedLevels
method BDraftInstance.CalcAllDraftInstanceForSelect
method BWorkObject.CreateOrUpdateWorkObject
method BWorkObject.PostSave
method BWorkObject.UpdateWorkobjectStatus