• State Suggested Answer
  • Locked Locked
  • Replies 2 replies
  • Answers 2 answers
  • Subscribers 93 subscribers
  • Views 1803 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

What is UID_PWORulerOrigin

dan
over 4 years ago

I'm using version 8 and creating a new Approval Procedure. The documentation says that I need to pass back a the uid of the approver/s and also a value for UID_PWORulerOrigin. The documentation doesn't tell me what's supposed to be fed into UID_PWORulerOrigin though. It suggests a SQL Function to use dbo.QER_FGIPWORulerOrigin and in the examples an XObjectKey is passed to it but I don't understand what the value is used for or what I should pass it. My Approval Procedure is fairly simple, it's just the manager of the uid_personinserted so that part is fine, just don't know what to pass as the second parameter.

Parents
  • 0 over 4 years ago

    Hi Dan,

    In our custom approval procedures we have always used:

    select <something> as UID_Person, NULL as UID_PWORulerOrigin

    from ........

    where .......

    And this always works just fine.  Doesn't answer your question as to why it's there but it will enable you to move on!

    If you use objectbrowser to filter PWODecisionRuleRulerDetect with "SQLQuery like '%fgipwo%'" you will find some examples.

    Regards, Barry.

Reply
  • 0 over 4 years ago

    Hi Dan,

    In our custom approval procedures we have always used:

    select <something> as UID_Person, NULL as UID_PWORulerOrigin

    from ........

    where .......

    And this always works just fine.  Doesn't answer your question as to why it's there but it will enable you to move on!

    If you use objectbrowser to filter PWODecisionRuleRulerDetect with "SQLQuery like '%fgipwo%'" you will find some examples.

    Regards, Barry.

Children
No Data