• State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 97 subscribers
  • Views 564 views
  • Users 0 members are here
Options
Related

Close attestations in bulk

l tonelli
5 months ago

Hello everyone,

what is the best way to close attestation cases in bulk?
We have a lot of pending attestation cases that have to be approved, is it possible to do it once and for all?

Thanks,
Lucrezia

Parents
  • 0 4 months ago

    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.

  • 0 4 months ago in reply to Barry Jackson

    Thank you so much for the information.

Reply Children
No Data