• State Verified Answer
  • Locked Locked
  • Replies 3 replies
  • Subscribers 94 subscribers
  • Views 5550 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Attestation with Product Owner as Approver

Pradeep Pola
over 7 years ago

 Hi Team,

 

I have scenario where i configured Product owner as approver ,But i need to transfer the attestation request to  product owner manager if attestation object and product owner is same person

for example 

userA is part of group1,group2,group3 and he is also owner of group1,group2,group3

 

when attestation is triggered for userA approval is coming to userA,instead how can i route the request to UserA's manager 

 

  • +1 over 7 years ago
    In your approval workflow add an approval step using the approval procedure CD (Calculated Decisions) and provided the SQL condition to test the ownership.

    You can then add the approval step for the product owner and your approval step for your manager of the product owner as downstream approval steps.

    For the product owner manager, create a custom approval procedure with the according condition.
  • 0 over 7 years ago
    I was adding CD and using below query but getting some error

    select 1 from (select a5.UID_Person as Approver,a4.UID_OrgRuler,a1.UID_AttestationCase,a6.UID_Person from Attestationcase a1

    Inner Join ADSAccountInADSGroup a2 on a1.ObjectKeyBase=a2.XObjectKey
    left Join ADSGroup a3 on a3.UID_ADSGroup=a2.UID_ADSGroup
    left Join AccProduct a4 on a4.UID_AccProduct=a3.UID_AccProduct
    Inner join PersonInAERole a5 on a5.UID_AERole=a4.UID_OrgRuler
    left join ADSAccount a6 on a2.UID_ADSAccount=a6.UID_ADSAccount

    where a6.UID_Person is not NULL) s1 where Approver = UID_person and UID_AttestationCase='@UID_attestationcase'

    sample query can be help full
  • 0 over 7 years ago
    The exact error message would be helpful.