• State Not Answered
  • Locked Locked
  • Replies 7 replies
  • Subscribers 93 subscribers
  • Views 3584 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

Approval procedure for delegations

marcos.perez.fontan
over 5 years ago

(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.

Parents
  • 0 over 5 years ago

    How do you determine that it is not working, any errors?

    Did you assign your approval policy to the service item for delegation?

  • 0 over 5 years ago in reply to Markus Weiss-Ehlers

    Thanks for the reply Markus.

    So we have an approval policy assigned to the Delegation service item, the approval policy has a workflow which contains just one step with one approval procedure. This approval procedure contains the query mentioned in the post.

    We do not have any errors, we only see how in the job queue the request is aborted due to the query not finding any results.

    If we change the approval procedure to any other, the delegation process works fine… So our guess is that the problem is coming from the query.

Reply
  • 0 over 5 years ago in reply to Markus Weiss-Ehlers

    Thanks for the reply Markus.

    So we have an approval policy assigned to the Delegation service item, the approval policy has a workflow which contains just one step with one approval procedure. This approval procedure contains the query mentioned in the post.

    We do not have any errors, we only see how in the job queue the request is aborted due to the query not finding any results.

    If we change the approval procedure to any other, the delegation process works fine… So our guess is that the problem is coming from the query.

Children