(Ver 7.1.2)
Hello again experts,
Let me explain what we want to do and how have we tried to do so.
So our aim is to create an approval workflow for delegations in which the person you are delegating to has to approve it (“accept” that delegation). Sounds pretty straight forward but unfortunately we are not getting the query just right.
We did not find any ootb way to do so, hence we created an approval procedure with the following query to find the “delegating to” identity as the approver:
Select
per.UID_Person as uid_person, dbo.QER_FGIPWORulerOrigin(per.XObjectKey) as UID_PWORulerOrigin
from Delegation del
join person per on del.UID_PersonReceiver = per.UID_Person
where del.UID_PersonWantsOrg = @uid_personwantsorg
It seems like the quey is not finding any identities and we cannot figure out why.
Is there any ootb way to implement this?
Any ideas of what could be wrong with our query?
Is it even possible to do what we aim to?
Thanks in advance.