• State Verified Answer
  • Replies 2 replies
  • Subscribers 95 subscribers
  • Views 1442 views
  • Users 0 members are here
Options
Related

Recalculate Attestor

despina schulz
over 2 years ago

Hi,

is there a way to recalculate the approver of an ongoing attestationcase? I saw an other similar thread, which works only for PWOHelperPWO. How can I programmatically recalculate the AttestationHelper?

Regards, Despina

Parents
  • +1 over 2 years ago

    Hi Despina,

    You can do it from server studio using this:

    Recalculate the attestation helpers – approvers

    Declare @procid varchar(38)

    Select @procid=newid()

    exec QBM_PDBQueueInsert_Single 'ATT-K-AttestationHelper', '<att case uid>', '', @procid

    You can run that SQL from an ExecuteSQL process step and/or you can configure/run it as pre-defined SQL.

    HTH, Barry.

Reply
  • +1 over 2 years ago

    Hi Despina,

    You can do it from server studio using this:

    Recalculate the attestation helpers – approvers

    Declare @procid varchar(38)

    Select @procid=newid()

    exec QBM_PDBQueueInsert_Single 'ATT-K-AttestationHelper', '<att case uid>', '', @procid

    You can run that SQL from an ExecuteSQL process step and/or you can configure/run it as pre-defined SQL.

    HTH, Barry.

Children