business logic query NavigInfoNew

Description

important note:
this query contains currently 2 outer-joins to table TranslationString
be very careful to add other outer-joins to this table (performance)

Parameters

iiLngID

integer

query condition

each BusComponent where

BusComponent.BusComponentIsActive = TRUE

each BusActivity (inner-join) where

BusActivity.BusComponent_ID = BusComponent.BusComponent_ID AND
BusActivity.BusActivitySequence > 0

each TranslationString1 (outer-join) where

TranslationString1.ParentObject_ID = BusActivity.BusActivity_ID AND
TranslationString1.Lng_ID = iiLngID

each TranslationString2 (outer-join) where

TranslationString2.ParentObject_ID = BusComponent.BusComponent_ID AND
TranslationString2.Lng_ID = iiLngID

query resultset tqNavigInfoNew

field name	data type	db field	description
tiBusActivity_ID	integer	BusActivity.BusActivity_ID	Record ID
tiBusActivityAccelerator	integer	BusActivity.BusActivityAccelerator	Accelerator
tcBusActivityButtonLabel	character	BusActivity.BusActivityButtonLabel	Button Label
tcBusActivityCode	character	BusActivity.BusActivityCode	Code
tcBusActivityDocActivity	character	BusActivity.BusActivityDocActivity	Document Activity
tcBusActivityFormName	character	BusActivity.BusActivityFormName	Form Name
tlBusActivityIsActive	logical	BusActivity.BusActivityIsActive	Active
tlBusActivityIsDefault	logical	BusActivity.BusActivityIsDefault	Default
tlBusActivityIsInstDep	logical	BusActivity.BusActivityIsInstDep	Instance Dependent
tcBusActivityLabel	character	BusActivity.BusActivityLabel	Activity
tcBusActivityLabelTranslated	character	TranslationString1.TranslationStringText	Translation
tcBusActivityMethodName	character	BusActivity.BusActivityMethodName	Method
tlBusActivityOpenForm	logical	BusActivity.BusActivityOpenForm	Open Form
tiBusActivitySequence	integer	BusActivity.BusActivitySequence	Seq
tiBusComponent_ID	integer	BusComponent.BusComponent_ID	BusComponent_ID
tcBusComponentCode	character	BusComponent.BusComponentCode	Component
tlBusComponentHasCustomFlds	logical	BusComponent.BusComponentHasCustomFlds	Has custom fields
tlBusComponentIsUserDefined	logical	BusComponent.BusComponentIsUserDefined	Indicates if this is a user defined business component
tcBusComponentLabel	character	BusComponent.BusComponentLabel	Label
	api annotation:		test annotation for BusComponentLabel
tcBusComponentLabelTranslated	character	TranslationString2.TranslationStringText	Translation

Internal usage

BLF

method Session.GetNavigationInformation