• State Verified Answer
  • Locked Locked
  • Replies 3 replies
  • Subscribers 94 subscribers
  • Views 5552 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 

 

Parents
  • 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
Reply
  • 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
Children
No Data