business logic query LookupControlProperties

Parameters

iiBusActivityID	integer
iiLayerType	integer
icBusComponentCode	character
icBusComponentLabel	character
icBusActivityCode	character
icBusActivityLabel	character
icForm	character

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 name	data type	db field	description
tiBusActivity_ID	integer	BusActivity.BusActivity_ID	Record ID
tcBusActivityCode	character	BusActivity.BusActivityCode	Code
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
tcControlPropertyControl	character	ControlProperty.ControlPropertyControl	fully qualified control name
tiControlPropertyLayerType	integer	ControlProperty.ControlPropertyLayerType	scope of the customization possible values: 1 (user level) 2 (role level) 3 (system level)
tiControlPropertyLayerValue	integer	ControlProperty.ControlPropertyLayerValue	userID when customized on user level roleID when customized on role level zero when customized on system level
tcControlPropertyName	character	ControlProperty.ControlPropertyName	property name
tcControlPropertyWindow	character	ControlProperty.ControlPropertyWindow	user interface name

Internal usage

BLF

method BControlProperty.GetCustomisedLevels