• State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 95 subscribers
  • Views 1043 views
  • Users 0 members are here
Options
Related

Attestations: How to find the pending approvals by approver

sam cogan
over 2 years ago

Hi all.

I am trying to find out if (and how) its possible to report on how many outstanding/pending attestations there are per approver at the back-end.

For example: Under attestation cases, we can see all the pending users who have an attestation against them but can these be grouped by approver?

Parents
  • 0 over 2 years ago

    Hi,

    This will give you the count of open attestations that a person is entitled to approve.  This could be on any level in the approval workflow.

    Select p.ccc_displayname, count(ac.uid_attestationcase) from attestationcase ac
    join AttestationHelper ah on ah.UID_AttestationCase = ac.UID_AttestationCase and ac.IsClosed=0
    join person p on p.uid_person = ah.uid_personhead
    group by p.ccc_displayname

    Note:  We have a custom attribute on Person for DisplayName ...... you could substitute that with InternalName.

    HTH, B.

Reply
  • 0 over 2 years ago

    Hi,

    This will give you the count of open attestations that a person is entitled to approve.  This could be on any level in the approval workflow.

    Select p.ccc_displayname, count(ac.uid_attestationcase) from attestationcase ac
    join AttestationHelper ah on ah.UID_AttestationCase = ac.UID_AttestationCase and ac.IsClosed=0
    join person p on p.uid_person = ah.uid_personhead
    group by p.ccc_displayname

    Note:  We have a custom attribute on Person for DisplayName ...... you could substitute that with InternalName.

    HTH, B.

Children
No Data