AnsweredAssumed Answered

Get Previous Approver's Manager ID

Question asked by Muzammil K on Nov 28, 2017
Latest reply on Dec 6, 2017 by Muzammil K

Like • Show 0 Likes0
Comment • 12

Hi,

I've designed a workflow that will have 2-step approvals depending on a form variable. If the checkbox in the form is checked, it's a 2 step approval, else if the checkbox is not selected it will be a single step approval.

The first approver is set to be Dynamic - Group, and any member from the group can approve it.

The second approver should be the first approver's manager.

My doubt is how do I retrieve the first approver's id as a variable and fetch the manager's id to set him as the second approver?

Thanks in advance.

Boris Lekumovich

Nov 28, 2017 2:43 AM

Correct Answer

Try the following (screenshot below)

After the approval node, create a SQL select node and create a transition.

In the SQL select node, right click and you will see a menu

Choose Previous Node Completed By -> Id - the variable should be: ${Previous_Node_completedBy_meu_userId}

Or directly choose Previous Node Completed By -> Supervisor - the variable will be: ${Previous_Node_completedBy_meu_supervisorFullName}

See the reply in context

No one else had this question

Outcomes

12 Replies

Boris Lekumovich Nov 28, 2017 2:43 AM
Unmark Correct
Correct Answer
Try the following (screenshot below)

After the approval node, create a SQL select node and create a transition.
In the SQL select node, right click and you will see a menu
Choose Previous Node Completed By -> Id - the variable should be: ${Previous_Node_completedBy_meu_userId}
Or directly choose Previous Node Completed By -> Supervisor - the variable will be: ${Previous_Node_completedBy_meu_supervisorFullName}

1 person found this helpful
Like • Show 1 Like1
Actions
- Muzammil K @ Boris Lekumovich on Nov 28, 2017 4:14 AM
  Mark Correct
  Correct Answer
  Hi Boris,
  Thanks for replying back.
  
  Is it advisable to map the supervisor Id using the id of previous approver with the T_RAW_USER table?
  query:
  SELECT SUPERVISOR_ID
  FROM T_RAW_USER
  WHERE USER_ID=${Previous_Node_completedBy_meu_userId}
  and SUPERVISOR_ID IS NOT NULL
  Like • Show 0 Likes0
  Actions
  - Boris Lekumovich @ Muzammil K on Nov 28, 2017 4:19 AM
    Mark Correct
    Correct Answer
    Not really.
    Use public views whenever possible. And in this case it is possible.
    Like • Show 0 Likes0
    Actions
    - Muzammil K @ Boris Lekumovich on Nov 28, 2017 4:29 AM
      Mark Correct
      Correct Answer
      Noted.
      I initially tried to query using the PV_USERS view, but the supervisor_id returned is not the user_id of the supervisor.
      
      what view do I use to map the supervisor_id return from PV_USERS, to fetch the user_id of the supervisor.
      
      I don't want to depend supervisorFULLNAME as that may not always be unique and may return 2 rows.
      Like • Show 0 Likes0
      Actions
      - Boris Lekumovich @ Muzammil K on Nov 28, 2017 4:40 AM
        Mark Correct
        Correct Answer
        Here is one way:
        
        select super.user_id as manager_id from pv_users usr inner join pv_users super on super.id = usr.SUPERVISOR_ID where usr.user_id = '${access_request_cri_meu_userId}'
        Like • Show 2 Likes2
        Actions
        Muzammil K @ Boris Lekumovich on Nov 28, 2017 6:03 AM
        Mark Correct
        Correct Answer
        Thanks for the query.
        
        PSB attached Image for the workflow design.
        For some reason the ${Previous_Node_completedBy_meu_userId} variable doesn't give the userid.
        
        When I use this query "SELECT ${Previous_Node_completedBy_meu_userId} as Approver_Id from dual", The workflow doesn't get the supervisor Id,
        
        But when I use a static id like "SELECT '123456' as Approver_Id from dual", the workflow can resolve the supervisor id and works fine.
        
        Any idea why ${Previous_Node_completedBy_meu_userId} is not returning the user ID?
        Like • Show 0 Likes0
        Actions
        Hemant Mandle @ Muzammil K on Nov 28, 2017 2:26 PM
        Mark Correct
        Correct Answer
        Hello Muzammil ,
        
        ${Previous_Node_completedBy_meu_userId} will return you id value, and not userid. You can get the userid value from pv_user view based on id returned by previous SQL.
        Like • Show 0 Likes0
        Actions
        Muzammil K @ Hemant Mandle on Nov 29, 2017 1:33 AM
        Mark Correct
        Correct Answer
        Thanks Hemant Mandle and Boris,
        But I've realized that the macro ${Previous_Node_completedBy_meu_userId} is not resolving.
        
        As we can see from the attached screenshot, the value is empty.
        The variable query is "SELECT ${Previous_Node_completedBy_meu_userId} as Approver_Id from dual" , I also tried combining the 2 queries of user_id and id from pv_users view, but still no value.
        
        Is there a way I can directly query the approverId from DB?
        if so, which View/Table?
        
        Like • Show 0 Likes0
        Actions
        Boris Lekumovich @ Muzammil K on Nov 29, 2017 2:05 AM
        Mark Correct
        Correct Answer
        Tested on 7.0.2 P3
        Wasn't able to make it work in SQL Select node and not in Send Email node.
        I suggest you open a support case.
        
        Meanwhile, check the following post - Approval CompletedBy information is not correct in email body
        There is a query you can try using to retrieve the approver. You might need to adjust it to your needs.
        Like • Show 0 Likes0
        Actions
        Muzammil K @ Boris Lekumovich on Nov 29, 2017 2:56 AM
        Mark Correct
        Correct Answer
        Thanks Boris,
        I modified the query to return the approver's User_id and when I tested it DB, it worked fine.
        However the query is depended on the CR_ID, and unfornutately the macro ${access_request_requestID} is not resolving as well so the query returns null because of this.
        
        I'll raise a support case for this, but I'm stuck without this being resolved.
        
        I thank you for your support and help.
        Like • Show 0 Likes0
        Actions
        Boris Lekumovich @ Muzammil K on Nov 29, 2017 4:03 AM
        Mark Correct
        Correct Answer
        Are you positive that the problem is with the ${access_request_requestID} variable?
        Like • Show 0 Likes0
        Actions
        Muzammil K @ Boris Lekumovich on Dec 6, 2017 12:34 AM
        Mark Correct
        Correct Answer
        Hi Boris,
        My SQL Select node was after the approval step, and for some reason ${access_request_requestID} was null.
        After rearranging the nodes so that the SQL select node is before the approval step, I'm getting the value in the variable now.
        thanks.
        Like • Show 0 Likes0
        Actions

Get Previous Approver's Manager ID

Outcomes

Related Content

Recommended Content