Hi,
I have a question and hope you can help here.
We have an Attestation Workflow with custom approval methods. When an Identity is temporarily deactivated I want to recalculate the corresponding Attestation Case (or bettter: just this approval step).
I already set up a scheduled event which calls a process. The process looks out for AttestationHelpers where the approver has IsTemporaryDeactivated = 1 and then calls an SQL script I found in this forum:
Dim SQL = String.Empty
sql = "Declare @procid varchar(38); " & "Select @procid = newid(); " _
& String.Format("exec QBM_PDBQueueInsert_Single 'ATT-K-AttestationHelper', '{0}', @procid;", $UID_AttestationCase$)
Value = sql
During testing I execute the schedule, the process for my test case starts and goes to History without any errors. Yet the AttestationCase Approvers have not been recalculated.
All approval methods also contain the condition IsTemporaryDeactivated = 0, so this should not be the problem.
Do you have any idea how I could recalculate the AttestationCase or what the problem is?
Thank you in advance for your help.
Best Regrads, Jano