Close attestations in bulk

Hi,

If you want/need the cases to be approved you'll need to know who the approver can/should be.

Then you can run this type of SQL:

Declare @procid varchar(38)

select @procid= newid()

Declare @objkeys dbo.QBM_YParameterList

exec dbo.QBM_PJobCreate_HOCallMethod 'AttestationCase','UID_AttestationCase=''<uid of att case>''',
@save=1,@GenProcID=@procid,@ObjectKeysAffected=@objkeys,@methodname='MakeDecision',
@Param1='<uid of approver>',@Param2='True',@Param3='<reason for approval>'

You'll need a single exec line per attestation case.

HTH, Barry.

Hi,

If you want/need the cases to be approved you'll need to know who the approver can/should be.

Then you can run this type of SQL:

Declare @procid varchar(38)

select @procid= newid()

Declare @objkeys dbo.QBM_YParameterList

exec dbo.QBM_PJobCreate_HOCallMethod 'AttestationCase','UID_AttestationCase=''<uid of att case>''',
@save=1,@GenProcID=@procid,@ObjectKeysAffected=@objkeys,@methodname='MakeDecision',
@Param1='<uid of approver>',@Param2='True',@Param3='<reason for approval>'

You'll need a single exec line per attestation case.

HTH, Barry.

Hello Barry, thank you for your quick answer.

I execute your code on SQL Server, replacing the UIDs and reason, but unfortunately this didn't close my attestation case.

I see in the queue that after the execution the process "Call method MakeDecision for object type Attestation Case" starts and finishes successfully, but then the attestation is not updated. Do you know why?

Was the step to be decided the last step in the workflow?  The case will only be closed if the last step is decided.

No, it wasn't. 
There is a function to make a decision for a step which is not the last of the workflow? 

Thank you so much for the information.