business logic query ControlPropertyByLayer

Description

!!! Has special conditions.

iiLayerType	integer
iiLayerValue	integer

each ControlProperty where

ControlProperty.ControlPropertyLayerType = iiLayerType AND
ControlProperty.ControlPropertyLayerValue = iiLayerValue

first BusActivity (inner-join) where

BusActivity.BusActivity_ID = ControlProperty.BusActivity_ID AND

first BusComponent (inner-join) where

BusComponent.BusComponent_ID = BusActivity.BusComponent_ID AND

field name	data type	db field	description
tiBusActivity_ID	integer	ControlProperty.BusActivity_ID	Business Activity
tcBusActivityCode	character	BusActivity.BusActivityCode	Code
tcBusComponentCode	character	BusComponent.BusComponentCode	Component
tiControlProperty_ID	integer	ControlProperty.ControlProperty_ID	Record ID
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

BLF