Back to OIM Explorer

SQL Object-Layer Bridge

Saved relation query: QBM_PJobCreate HOCallMethod HOFireEvent DialogMethod QBMEvent

1SQL module/trigger
2QBM_PJobCreate helper
3HOCallMethod/DialogMethod or HOFireEvent/QBMEvent
4Customizer/source evidence
5Generated process or method result

Related Evidence

Stored ProcedureSandbox DB
dbo.ATT_ZAttestationReminder

Stored Procedure. HOCallMethod -> AttestationCase.MakeDecision at line 38; HOCallMethod -> AttestationCase.ESCALATE at line 38; HOCallMethod -> AttestationCase.Abort at line 38; HOCallMethod -> AttestationCase.ESCALATE at line 42

Open source
Knowledge PageWorkspace Evidence
OIM KB Update Run - QBM_PJobCreate Methods and Events

OIM KB Update Run QBM PJobCreate Methods and Events Scope User request: research which methods and events can be used by the QBM PJobCreate stored procedures, especially the object layer HOCallMethod and HOFireEvent variants. Work Done Queried live sandbox DB metadata for QBM PJobCreate HOCallMethod and QBM PJobCreate

SQL -> EventWorkspace Evidence
_paramName1.@event

QBM_PJobCreate_HOFireEvent_B @BasisObjectType, @WhereClause, @EventName = @event , @GenProcID = @GenProcID, @AdditionalObjectKeysAffected = DEFAULT, @p2 = N'_paramName1', @v2 = N'StopTime', @p3 = N'_paramValue1', @v3 = @StopTimeFull , @p4 …

Open source
SQL -> EventWorkspace Evidence
.' , @EventName , '

QBM_PJobCreate_HOFireEvent_L ''@TargetTableView@'', @EntriesToFire, ''' , @EventName , ''', ''@GenProcID'' , @AddonElements , @isToFreezeOnError = 1 ' ) select @SQLCmdInsert = REPLACE(@SQLCmdInsert, '@XObjectKey@', 'dbo.QBM_FCVElementToObj…

Open source
SQL -> EventWorkspace Evidence
.@EventName

QBM_PJobCreate_HOFireEvent @objecttype , @Sammler , @EventName , @GenProcID , @ObjectKeysAffected , @ConnectionVariables , @AuthenticationString , @SingleTransaction , @p2, @v2 , @p3, @v3 , @p4, @v4 , @p5, @v5 , @p6, @v6 ,@p7, @v7 , @p8, @…

Open source
SQL -> Object MethodWorkspace Evidence
.@save

QBM_PJobCreate_HOCallMethod @objecttype , @Sammler , @save , @MethodName , @GenProcID , @ObjectKeysAffected , @ConnectionVariables , @AuthenticationString , @SingleTransaction , @param1 , @param2 , @param3 , @param4, @param5 , @param6, @pa…

Open source
SQL -> EventWorkspace Evidence
' , @TargetTable , '., concat(

QBM_PJobCreate_HOFireEvent_L ''' , @TargetTable , ''', @EntriesToFire, ''Insert'', ''@GenProcID'' , @AddonElements , @isToFreezeOnError = 1 ' ) end select @SQLCmdInsert = REPLACE(@SQLCmdInsert, '@XObjectKey@', concat('dbo.QBM_FCVElementToO…

Open source
SQL -> EventWorkspace Evidence
' , @TargetTable , '.' , @EventName , '

QBM_PJobCreate_HOFireEvent_L ''' , @TargetTable , ''', @EntriesToFire, ''' , @EventName , ''', ''@GenProcID'' , @AddonElements , @isToFreezeOnError = 1 ' ) end select @SQLCmdInsert = REPLACE(@SQLCmdInsert, '@XObjectKey@', concat('dbo.QBM_F…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.@AbortMethod

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = @AbortMethod , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = '#LDS#Automatic system approval: Number of …

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.@AbortMethod

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = @AbortMethod , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = '#LDS#Automatic system approval: Number of …

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.@AbortMethod

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = @AbortMethod , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = '#LDS#Automatic system approval: Number of …

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.@AbortMethod

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = @AbortMethod , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = '#LDS#Automatic system approval: Number of …

Open source
SQL -> EventWorkspace Evidence
AttestationCase.@EventName

QBM_PJobCreate_HOFireEvent_B 'AttestationCase', @cond, @EventName, @GenProcID , @AdditionalObjectKeysAffected = DEFAULT , @checkForExisting = 0 , @BasisObjectKey = @BasisObjectKey , @p2 = '_ParamName1', @v2 = 'SubLevelNumber' , @p3 = '_Par…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.Abort

QBM_PJobCreate_HOCallMethod_B @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenprocID , @AdditionalObjectKeysAffected = DEFAULT , @param1 = '#LDS#Automatic system approval: wor…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.Abort

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = '#LDS#Automatic system approval: object to attes…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.Abort

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = '#LDS#Automatic system approval: Policy is inact…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.Abort

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = '#LDS#Automatic system approval: No approver ava…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.Abort

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = '#LDS#Automatic system approval: Policy is inact…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.Abort

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = '#LDS#Automatic system approval: No approver ava…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.Abort

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = '#LDS#Automatic system approval: Not enough appr…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.Abort

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = '#LDS#Automatic system approval: No approver ava…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.Abort

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = '#LDS#Automatic system approval: Not enough appr…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.Abort

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = '#LDS#Automatic system approval: Not enough appr…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.Abort

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = '#LDS#Automatic system approval: Not enough appr…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.Abort

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 ='#LDS#Automatic system approval: "Abort" due to t…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.Abort

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 ='#LDS#Automatic system approval: "Abort" due to t…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.Abort

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 ='#LDS#Automatic system approval: "Abort" due to t…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.Abort

QBM_PJobCreate_HOCallMethod_L @objecttype = 'AttestationCase' , @XObjectKeys = @ElementsToClose , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenprocID , @AdditionalObjectKeysAffected = DEFAULT , @param1 = '#LDS#Automatic system appr…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.ESCALATE

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'ESCALATE' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = 'sa' , @Param2 = '#LDS#Automatic system appro…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.ESCALATE

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'ESCALATE' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = 'sa' , @Param2 = '#LDS#Automatic system appro…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.ESCALATE

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'ESCALATE' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.ESCALATE

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'ESCALATE' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = 'sa' , @Param2 = '#LDS#Automatic system appro…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.ESCALATE

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'ESCALATE' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = 'sa' , @Param2 = '#LDS#Automatic system appro…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.ESCALATE

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'ESCALATE' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = 'sa' , @Param2 = '#LDS#Automatic system appro…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.ESCALATE

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'ESCALATE' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = 'sa' , @Param2 = '#LDS#Automatic system appro…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.ESCALATE

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'ESCALATE' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = 'sa' , @Param2 = '#LDS#Automatic system appro…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.ESCALATE

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'ESCALATE' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = 'sa' , @Param2 = '#LDS#Automatic system appro…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.ESCALATE

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'ESCALATE' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = 'sa' , @Param2 = '#LDS#Automatic system appro…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.ESCALATE

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'ESCALATE' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = 'sa' , @Param2 = '#LDS#Automatic system appro…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.MakeDecision

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @cond , @save = 1 , @MethodName = 'MakeDecision' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = 'sa' , @param2 = @decision , @Param3 = @rea…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.MakeDecision

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @cond , @save = 1 , @MethodName = 'MakeDecision' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = 'sa' , @param2 = @decision , @param3 = @rea…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationCase.MakeDecision

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'MakeDecision' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = 'sa' , @Param2 = @AbortMethod , @Param3 =…

Open source
SQL -> EventWorkspace Evidence
AttestationHelper.DecisionRequired

QBM_PJobCreate_HOFireEvent_B 'AttestationHelper', @WhereclauseForMail, 'DecisionRequired' , @GenProcID , @AdditionalObjectKeysAffected = DEFAULT , @checkForExisting = 1 , @priority = 10 , @BasisObjectKey = @ObjectkeyForMail select @Element…

Open source
SQL -> EventWorkspace Evidence
AttestationHelper.DecisionRequired

QBM_PJobCreate_HOFireEvent_B 'AttestationHelper', @WhereclauseForMail, 'DecisionRequired' , @GenProcID , @AdditionalObjectKeysAffected = DEFAULT , @checkForExisting = 1 , @priority = 10 , @BasisObjectKey = @ObjectkeyForMail select @Element…

Open source
SQL -> EventWorkspace Evidence
AttestationHelper.Remind

QBM_PJobCreate_HOFireEvent_B 'AttestationHelper', @WhereclauseForMail, 'Remind', @GenProcID , @AdditionalObjectKeysAffected = DEFAULT , @checkForExisting = 1 , @BasisObjectKey = @ObjectkeyForMail end select @ElementIndex += 1 end update At…

Open source
SQL -> Object MethodWorkspace Evidence
AttestationPolicy.CompleteCasesUnderConstruction

QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationPolicy' , @WhereClause = @HOWhereClause , @save = 1 , @MethodName = 'CompleteCasesUnderConstruction' , @GenProcID = @GenProcID , @ObjectKeysAffected = default , @Param1 = @ParamUIDs , @…

Open source
SQL -> EventWorkspace Evidence
AttestationPolicy.RebuildWhereClause

QBM_PJobCreate_HOFireEvent 'AttestationPolicy', '1=1' , 'RebuildWhereClause', @GenProcID, @objectKeysAffected = default exec QBM_PDBQueueInsert_Single 'QER-K-DynamicGroupMakeTrigger', '', '', @GenProcID END TRY BEGIN CATCH exec QBM_PSessio…

Open source
SQL -> EventWorkspace Evidence
AttestationPolicy.RebuildWhereClause

QBM_PJobCreate_HOFireEvent 'AttestationPolicy', '1=1' , 'RebuildWhereClause', @GenProcID, @objectKeysAffected = default exec QBM_PDBQueueInsert_Single 'QER-K-DynamicGroupMakeTrigger', '', '', @GenProcID END TRY BEGIN CATCH exec QBM_PSessio…

Open source
SQL -> EventWorkspace Evidence
DialogDatabase.SendMail

QBM_PJobCreate_HOFireEvent @objecttype = 'DialogDatabase' , @whereclause = 'IsMainDatabase = 1', @EventName = 'SendMail', @GenProcID = @GenProcID, @ObjectKeysAffected = @AdditionalObjectKeysAffected, @p2 = N'_paramName1' , @v2 = N'pcSubjec…

Open source
SQL -> EventWorkspace Evidence
DialogDatabase.SendRichMail

QBM_PJobCreate_HOFireEvent @objecttype = 'DialogDatabase', @whereclause = 'IsMainDatabase = 1' , @EventName = 'SendRichMail', @GenProcID = @GenProcID, @ObjectKeysAffected = @AdditionalObjectKeysAffected, @p2 = N'_paramName1', @v2 = N'pcMai…

Open source
SQL -> EventWorkspace Evidence
DialogDatabase.UpdateSystemSyncs

QBM_PJobCreate_HOFireEvent 'DialogDatabase', 'IsMainDatabase = 1' , 'UpdateSystemSyncs', @GenProcID, @ObjectKeysAffected = default , @Startat = @Starten end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH N…

Open source
SQL -> EventWorkspace Evidence
DialogDatabase.UpdateSystemSyncs

QBM_PJobCreate_HOFireEvent 'DialogDatabase', 'IsMainDatabase = 1' , 'UpdateSystemSyncs', @GenProcID, @ObjectKeysAffected = default , @Startat = @Starten end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH N…

Open source
SQL -> EventWorkspace Evidence
DialogDatabase.UpdateSystemSyncs

QBM_PJobCreate_HOFireEvent 'DialogDatabase' , 'IsMainDatabase = 1', 'UpdateSystemSyncs', @GenProcID, @ObjectKeysAffected = default , @Startat = @Starten end end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1…

Open source
SQL -> EventWorkspace Evidence
DialogDatabase.UpdateSystemSyncs

QBM_PJobCreate_HOFireEvent 'DialogDatabase', 'IsMainDatabase = 1', 'UpdateSystemSyncs', @GenProcID, @ObjectKeysAffected = default , @Startat = @Starten end end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1)…

Open source
SQL -> EventWorkspace Evidence
DialogDatabase.UpdateSystemSyncs

QBM_PJobCreate_HOFireEvent 'DialogDatabase' , 'IsMainDatabase = 1', 'UpdateSystemSyncs', @GenProcID, @ObjectKeysAffected = default , @Startat = @Starten end end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1…

Open source
SQL -> EventWorkspace Evidence
DialogDeferredOperation.EXECUTE

QBM_PJobCreate_HOFireEvent 'DialogDeferredOperation', @whereclause, 'EXECUTE', @GenProcid , @ObjectKeysAffected = @ObjectKeysPerRun , @BasisObjectKey = @BasisObjectKey select @ElementIndex += 1 end update DialogDeferredOperation set xtouch…

Open source
SQL -> EventWorkspace Evidence
HelperHeadPerson.Insert

QBM_PJobCreate_HOFireEvent_L 'HelperHeadPerson', @EntriesToFire, 'Insert', @GenProcID , @AdditionalObjectkeysAffected = default , @isToFreezeOnError = 1 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH N…

Open source
SQL -> EventWorkspace Evidence
HelperHeadPerson.Insert

QBM_PJobCreate_HOFireEvent_L 'HelperHeadPerson', @EntriesToFire, 'Insert', @GenProcID , @AdditionalObjectkeysAffected = default , @isToFreezeOnError = 1 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH N…

Open source
SQL -> EventWorkspace Evidence
HelperHeadPerson.Insert

QBM_PJobCreate_HOFireEvent_L 'HelperHeadPerson', @EntriesToFire, 'Insert', @GenProcID , @AdditionalObjectkeysAffected = default , @isToFreezeOnError = 1 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH N…

Open source
SQL -> EventWorkspace Evidence
HelperHeadPerson.Insert

QBM_PJobCreate_HOFireEvent_L 'HelperHeadPerson', @EntriesToFire, 'Insert', @GenProcID , @AdditionalObjectkeysAffected = default , @isToFreezeOnError = 1 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH N…

Open source
SQL -> EventWorkspace Evidence
ITShopOrg.DeletePRNode

QBM_PJobCreate_HOFireEvent_L 'ITShopOrg', @EntriesToFire ,'DeletePRNode', @GenProcID , @CheckForExisting = 1 , @AdditionalObjectKeysAffected = DEFAULT select @RowCounterNodeCheck += 1 select @ElementIndex += 1 end select @SQLCmd = string_a…

Open source
SQL -> EventWorkspace Evidence
JobQueue.FROZENDETECT

QBM_PJobCreate_HOFireEvent 'JobQueue', @SQLcmd, 'FROZENDETECT', @GenProcID , @ObjectKeysAffected = DEFAULT update @JobQueueShadow set ready2exe = N'FALSE' , IsRecordModified = 1 , IsRecordModifiedExtended = 1 , XDateUpdated = @XDateSpecial…

Open source
SQL -> EventWorkspace Evidence
JobQueue.OVERLIMITDETECT

QBM_PJobCreate_HOFireEvent 'JobQueue', @SQLWhereClause, 'OVERLIMITDETECT', @GenProcID = @GenProcID , @ObjectKeysAffected = DEFAULT select @ElementIndex += 1 end end end NachLimitationCount: if exists (select top 1 1 from inserted i where i…

Open source
SQL -> EventWorkspace Evidence
JobQueue.OVERLIMITWARNING

QBM_PJobCreate_HOFireEvent 'JobQueue', @SQLWhereClause, 'OVERLIMITWARNING', @GenProcID = @GenProcID , @ObjectKeysAffected = DEFAULT , @checkForExisting = 1 select @ElementIndex += 1 end end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd…

Open source
SQL -> EventWorkspace Evidence
JobQueue.OVERLIMITWARNING

QBM_PJobCreate_HOFireEvent 'JobQueue', @SQLWhereClause, 'OVERLIMITWARNING', @GenProcID = @GenProcID , @ObjectKeysAffected = DEFAULT , @checkForExisting = 1 select @ElementIndex += 1 end end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd…

Open source
SQL -> EventWorkspace Evidence
PersonHasQERResource.Assign

QBM_PJobCreate_HOFireEvent_L 'PersonHasQERResource', @EntriesToFire_Assign1 , @EventName = 'Assign' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 1 ' , @AdditionalObjectKeysAffected = @Additi…

SQL -> EventWorkspace Evidence
PersonHasQERResource.Remove

QBM_PJobCreate_HOFireEvent_L 'PersonHasQERResource', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Additi…

SQL -> EventWorkspace Evidence
PersonHasQERResource.Remove

QBM_PJobCreate_HOFireEvent_L 'PersonHasQERResource', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Additi…

SQL -> EventWorkspace Evidence
PersonHasTSBAccountDef.Assign

QBM_PJobCreate_HOFireEvent_L 'PersonHasTSBAccountDef', @EntriesToFire_Assign1 , @EventName = 'Assign' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 1 ' , @AdditionalObjectKeysAffected = @Addi…

SQL -> EventWorkspace Evidence
PersonHasTSBAccountDef.Remove

QBM_PJobCreate_HOFireEvent_L 'PersonHasTSBAccountDef', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Addi…

SQL -> EventWorkspace Evidence
PersonHasTSBAccountDef.Remove

QBM_PJobCreate_HOFireEvent_L 'PersonHasTSBAccountDef', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Addi…

SQL -> Object MethodWorkspace Evidence
personwantsorg.@AbortMethod

QBM_PJobCreate_HOCallMethod 'personwantsorg', @SQLcmd, @save = 1 , @Methodname = @AbortMethod , @GenProcID = @GenProcID , @ObjectKeysAffected = DEFAULT , @Param1 = '#LDS#Automatic system approval: Number of days has been exceeded, as speci…

Open source
SQL -> Object MethodWorkspace Evidence
personwantsorg.@AbortMethod

QBM_PJobCreate_HOCallMethod 'personwantsorg', @SQLcmd, @save = 1 , @Methodname = @AbortMethod , @GenProcID = @GenProcID , @ObjectKeysAffected = DEFAULT , @Param1 = '#LDS#Automatic system approval: Number of days has been exceeded, as speci…

Open source
SQL -> Object MethodWorkspace Evidence
personwantsorg.@AbortMethod

QBM_PJobCreate_HOCallMethod 'personwantsorg', @SQLcmd, @save = 1 , @Methodname = @AbortMethod , @GenProcID = @GenProcID , @ObjectKeysAffected = DEFAULT , @Param1 = '#LDS#Automatic system approval: "Abort" due to timeout.|' , @Param2 = @UID…

Open source
SQL -> Object MethodWorkspace Evidence
personwantsorg.@AbortMethod

QBM_PJobCreate_HOCallMethod 'personwantsorg', @SQLcmd, @save = 1 , @Methodname = @AbortMethod , @GenProcID = @GenProcID , @ObjectKeysAffected = DEFAULT , @Param1 = '#LDS#Automatic system approval: "Abort" due to timeout.|' , @Param2 = @UID…

Open source
SQL -> Object MethodWorkspace Evidence
personwantsorg.@AbortMethod

QBM_PJobCreate_HOCallMethod 'personwantsorg', @SQLcmd, @save = 1 , @Methodname = @AbortMethod , @GenProcID = @GenProcID , @ObjectKeysAffected = DEFAULT , @Param1 = '#LDS#Automatic system approval: "Abort" due to timeout.|' , @Param2 = @UID…

Open source
SQL -> Object MethodWorkspace Evidence
PersonWantsOrg.@AbortMethod

QBM_PJobCreate_HOCallMethod 'PersonWantsOrg', @cond, @save = 1, @MethodName = @AbortMethod , @GenProcID = @GenProcID , @ObjectKeysAffected = DEFAULT , @param1 = @reason , @IsToFreezeOnError = 1 , @Retries = 3 , @checkForExisting = 1 , @Whe…

Open source
SQL -> EventWorkspace Evidence
personwantsorg.@EventName

QBM_PJobCreate_HOFireEvent_B 'personwantsorg', @cond, @EventName , @GenProcID , @AdditionalObjectKeysAffected = DEFAULT , @checkForExisting = 0 , @BasisObjectKey = @BasisObjectKey , @p2 = '_ParamName1', @v2 = 'SubLevelNumber' , @p3 = '_Par…

Open source
SQL -> Object MethodWorkspace Evidence
personwantsorg.Abort

QBM_PJobCreate_HOCallMethod @objecttype = 'personwantsorg' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = '#LDS#Closing delegation because its source was w…

Open source
SQL -> Object MethodWorkspace Evidence
personwantsorg.Abort

QBM_PJobCreate_HOCallMethod @objecttype = 'personwantsorg' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenprocID , @ObjectKeysAffected = DEFAULT , @param1 = '#LDS#Closing delegation because its source was w…

Open source