project BLF > class BBusinessComponent > business logic query BusActivityByActCompDefault

Description

BusActivityByActCompDefault; query on table busActivity (with join to buComponent) with parameters on busAct.busActCode, BusAct.BusActIsDefault and busComp.BusCompCode


Parameters


icBusActitvityCodecharacter
icBusComponentCodecharacter
ilBusActiivtyIsDefaultlogical
ilBusActivytIsActivelogical


query condition


  each BusActivity where
BusActivity.BusActivityCode = icBusActitvityCode AND
BusActivity.BusActivityIsDefault = ilBusActiivtyIsDefault AND
BusActivity.BusActivityIsActive = ilBusActivytIsActive

      first BusComponent (inner-join) where
BusComponent.BusComponent_ID = BusActivity.BusComponent_ID AND
BusComponent.BusComponentCode = icBusComponentCode

      each Resources (inner-join) where
Resources.BusActivity_ID = BusActivity.BusActivity_ID AND


query resultset tqBusActivityByActCompDefault


field namedata typedb fielddescription
tiResource_IDintegerResources.Resource_IDRecord ID
tiBusComponent_IDintegerBusActivity.BusComponent_IDBusiness Component
tcBusComponentCodecharacterBusComponent.BusComponentCodeComponent
tiBusActivity_IDintegerBusActivity.BusActivity_IDRecord ID
tcBusActivityCodecharacterBusActivity.BusActivityCodeCode
tiBusActivitySequenceintegerBusActivity.BusActivitySequenceSeq
tlBusActivityIsActivelogicalBusActivity.BusActivityIsActiveActive
tlBusActivityIsDefaultlogicalBusActivity.BusActivityIsDefaultDefault


Internal usage


BLF
method BReportTranslation.apiSynchronise
method BResource.ApiLinkResource
method breport.GetReportLabels

QadFinancials
method BRole.ApiCreateCIApproveRole