project BLF > class BBusinessComponent > business logic query BusActivityPrim

Description

BusActivityPrim; converts the logical prim-key into the physical prim-key and vice-versa

Parameters

iiBusActivityID	integer	BusActivityID
icBusActivityCode	character
icBusComponentCode	character

query condition

each BusActivity where

BusActivity.BusActivity_ID = iiBusActivityID AND
BusActivity.BusActivityCode = icBusActivityCode

first BusComponent (inner-join) where

BusComponent.BusComponent_ID = BusActivity.BusComponent_ID AND
BusComponent.BusComponentCode = icBusComponentCode

query resultset tqBusActivityPrim

field name	data type	db field	description
tcBusActivityCode	character	BusActivity.BusActivityCode	Code
tiBusComponent_ID	integer	BusComponent.BusComponent_ID	BusComponent_ID
tcBusComponentCode	character	BusComponent.BusComponentCode	Component
tiBusActivity_ID	integer	BusActivity.BusActivity_ID	Record ID
tcBusActivityLabel	character	BusActivity.BusActivityLabel	Activity
tcBusComponentLabel	character	BusComponent.BusComponentLabel	Label
	api annotation:		test annotation for BusComponentLabel

Internal usage

BLF

method business.apiActivityIsAllowed
method database.StoreState
method BControlProperty.DataLoadByInput
method BFieldSecurity.ValidateComponent
method BReportTranslation.ValidateComponent
method BReportVariant.apiGetVariant
method BReportVariant.ApiGetVariantInformation
method BResource.DataLoadByInput
method BScanDaemon.ValDraftsEnabled
method BWorkClass.ValidateWorkClass
method BWorkObject.PostSave
method BWorkObject.ValidateComponent
read related business field(s) on tControlProperty.BusActivity_ID
read related business field(s) on tFieldSecurity.BusActivity_ID
read related business field(s) on tReportTranslation.ReportBusActivity_ID
read related business field(s) on tResources.BusActivity_ID
read related business field(s) on tRptRequest.BusActivity_ID
read related business field(s) on tWorkClass.BusActivity_ID
read related business field(s) on tWorkObject.BusActivity_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tControlProperty.BusActivity_ID
validate related business field(s) on tResources.BusActivity_ID
validate related business field(s) on tRptRequest.BusActivity_ID