project BLF > class BWorkClass > business logic query WorkClassByDescr


Parameters


icWorkClassDescriptioncharacter


query condition


  each WorkClass where
WorkClass.WorkClassDescription = icWorkClassDescription

      first BusActivity (conditional-join) where
BusActivity.BusActivity_ID = WorkClass.BusActivity_ID AND

      first BusComponent (conditional-join) where
BusComponent.BusComponent_ID = WorkClass.BusComponent_ID AND

      first ObjectFlexStatus (conditional-join) where
ObjectFlexStatus.ObjectFlexStatus_ID = WorkClass.ObjectFlexStatus_ID AND

      first Role (conditional-join) where
Role.Role_ID = WorkClass.Role_ID AND

      first Usr (conditional-join) where
Usr.Usr_ID = WorkClass.Usr_ID AND


query resultset tqWorkClassByDescr


field namedata typedb fielddescription
tiBusActivity_IDintegerBusActivity.BusActivity_IDRecord ID
tcBusActivityCodecharacterBusActivity.BusActivityCodeCode
tcBusActivityLabelcharacterBusActivity.BusActivityLabelActivity
tiBusComponent_IDintegerBusComponent.BusComponent_IDBusComponent_ID
tcBusComponentCodecharacterBusComponent.BusComponentCodeComponent
tcBusComponentLabelcharacterBusComponent.BusComponentLabelLabel
api annotation:test annotation for BusComponentLabel
tiObjectFlexStatus_IDintegerWorkClass.ObjectFlexStatus_IDCustom Object Status
tcObjectFlexStatusCodecharacterObjectFlexStatus.ObjectFlexStatusCodeCode
tiRole_IDintegerWorkClass.Role_IDRole
tcRoleNamecharacterRole.RoleNameRole Name
tiUsr_IDintegerWorkClass.Usr_IDUser
tcUsrNamecharacterUsr.UsrNameUser Name
tiWorkClass_IDintegerWorkClass.WorkClass_IDRecord ID
tcWorkClassDescriptioncharacterWorkClass.WorkClassDescriptionDescription
tcWorkClassInstructioncharacterWorkClass.WorkClassInstructionInstruction
tlWorkClassIsActivelogicalWorkClass.WorkClassIsActiveActive
tlWorkClassIsReturnToSenderlogicalWorkClass.WorkClassIsReturnToSenderReturn to Sender
tlWorkClassIsSendMaillogicalWorkClass.WorkClassIsSendMailE-mail Notification
tcWorkClassScopeBusinessFldcharacterWorkClass.WorkClassScopeBusinessFldBusiness Field


Internal usage


BLF
method BWorkClass.ApiLoad