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

iiBusComponentID	integer	BusComponentID
icBusComponentCode	character
icBusComponentLabel	character	BusComponentLabel
iiBusActivityID	integer	BusActivity-id
icBusActivityCode	character	BusActivityCode
icBusActivityLabel	character	BusActivityLabel

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 name	data type	db field	description
tiBusActivity_ID	integer	BusActivity.BusActivity_ID	Record ID
tcBusActivityCode	character	BusActivity.BusActivityCode	Code
tlBusActivityIsDefault	logical	BusActivity.BusActivityIsDefault	Default
tcBusActivityLabel	character	BusActivity.BusActivityLabel	Activity
tiBusComponent_ID	integer	BusComponent.BusComponent_ID	BusComponent_ID
tcBusComponentCode	character	BusComponent.BusComponentCode	Component
tcBusComponentLabel	character	BusComponent.BusComponentLabel	Label
	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