AnsweredAssumed Answered

Approval CompletedBy information is not correct in email body

Question asked by Ece YILDIRIM on Jul 18, 2016
Latest reply on Jul 30, 2016 by Ece YILDIRIM

Like • Show 0 Likes0
Comment • 3

Hello,

- In one of our approval nodes we are dynamically calculating the approvers (can be multiple user). (Picture 1)

- Then when one of the resources rejects the request, in the email sent, we need to be able to identify which is the exact resource who performed rejection among many. However, in current email sent it displayed all resources the task is assigned to (Picture 2 - 2 resources are assigned in the example)

- When we checked from approval details list, we can identify the resource who took action (Picture 3)

- Please see the email configuration (Picture 4) and let us know how we can realize required behavior.

Picture 1

Picture 2

Picture 3

Picture 4

Ece YILDIRIM Jul 30, 2016 12:30 PM

Correct Answer

Below query is being used

select DISTINCT CONCAT( meu.First_name, CONCAT(' ', meu.Last_name)) as USER_REJECTED
From
T_MASTER_ENTERPRISE_USERS meu
JOIN WP_WORK_ITEM wpi
ON meu.ID = wpi.ASSIGNED_TO
WHERE (wpi.PROCI_ID,wpi.PROCI_DB) IN
(
SELECT PROCI_ID, PROCI_DB
FROM WP_PROCI
WHERE PROCI_REF=
(
    SELECT PROCI_REF
    FROM WP_PROCI
    WHERE PROCI_ID= (
      select PROCI_ID
      from WP_PROCI
      where cr_id = CR_ID
      and name like '%RTYY - Role Creation / Modification Approval - First Step%'
      --and Button_selected like 'Rejected'
    )
    AND PROCI_DB='WPDS'
)
)
AND BUTTON_SELECTED like 'Rejected'

See the reply in context

No one else had this question

Outcomes

Ece YILDIRIM Jul 22, 2016 2:23 AM

Any comments please?

Actions

Boris Lekumovich

Jul 24, 2016 3:41 AM

Probably not the most elegant approach, but give this a try

SELECT MEU.ID FROM 
            T_MASTER_ENTERPRISE_USERS MEU 
        JOIN 
            WP_WORK_ITEM WI 
        ON WI.ASSIGNED_TO=MEU.ID 
        WHERE (WI.PROCI_ID,WI.PROCI_DB) IN 
            (SELECT PROCI_ID, PROCI_DB FROM WP_PROCI WHERE PROCI_REF=(SELECT PROCI_REF FROM WP_PROCI WHERE PROCI_ID=<value from workflow> AND PROCI_DB='WPDS'))

The values for PROCI_ID and PROCI_DB are taken from the workflow properties (see screenshot below)

Not sure what will be the behavior if you have multiple approval nodes in the same workflow.

In any case you should test it to see if this works.

Actions

Ece YILDIRIM @ Boris Lekumovich on Jul 30, 2016 12:30 PM

Below query is being used

select DISTINCT CONCAT( meu.First_name, CONCAT(' ', meu.Last_name)) as USER_REJECTED
From
T_MASTER_ENTERPRISE_USERS meu
JOIN WP_WORK_ITEM wpi
ON meu.ID = wpi.ASSIGNED_TO
WHERE (wpi.PROCI_ID,wpi.PROCI_DB) IN
(
SELECT PROCI_ID, PROCI_DB
FROM WP_PROCI
WHERE PROCI_REF=
(
    SELECT PROCI_REF
    FROM WP_PROCI
    WHERE PROCI_ID= (
      select PROCI_ID
      from WP_PROCI
      where cr_id = CR_ID
      and name like '%RTYY - Role Creation / Modification Approval - First Step%'
      --and Button_selected like 'Rejected'
    )
    AND PROCI_DB='WPDS'
)
)
AND BUTTON_SELECTED like 'Rejected'

Actions

3 Replies

Ece YILDIRIM Jul 22, 2016 2:23 AM
Mark Correct
Correct Answer
Any comments please?
Like • Show 0 Likes0
Actions
Boris Lekumovich Jul 24, 2016 3:41 AM
Mark Correct
Correct Answer
Probably not the most elegant approach, but give this a try
```
SELECT MEU.ID FROM 
            T_MASTER_ENTERPRISE_USERS MEU 
        JOIN 
            WP_WORK_ITEM WI 
        ON WI.ASSIGNED_TO=MEU.ID 
        WHERE (WI.PROCI_ID,WI.PROCI_DB) IN 
            (SELECT PROCI_ID, PROCI_DB FROM WP_PROCI WHERE PROCI_REF=(SELECT PROCI_REF FROM WP_PROCI WHERE PROCI_ID=<value from workflow> AND PROCI_DB='WPDS'))
```
The values for PROCI_ID and PROCI_DB are taken from the workflow properties (see screenshot below)

Not sure what will be the behavior if you have multiple approval nodes in the same workflow.
In any case you should test it to see if this works.
Like • Show 0 Likes0
Actions
- Ece YILDIRIM @ Boris Lekumovich on Jul 30, 2016 12:30 PM
  Unmark Correct
  Correct Answer
  Below query is being used
  select DISTINCT CONCAT( meu.First_name, CONCAT(' ', meu.Last_name)) as USER_REJECTED
  From
  T_MASTER_ENTERPRISE_USERS meu
  JOIN WP_WORK_ITEM wpi
  ON meu.ID = wpi.ASSIGNED_TO
  WHERE (wpi.PROCI_ID,wpi.PROCI_DB) IN
  (
  SELECT PROCI_ID, PROCI_DB
  FROM WP_PROCI
  WHERE PROCI_REF=
  (
      SELECT PROCI_REF
      FROM WP_PROCI
      WHERE PROCI_ID= (
        select PROCI_ID
        from WP_PROCI
        where cr_id = CR_ID
        and name like '%RTYY - Role Creation / Modification Approval - First Step%'
        --and Button_selected like 'Rejected'
      )
      AND PROCI_DB='WPDS'
  )
  )
  AND BUTTON_SELECTED like 'Rejected'
  Like • Show 2 Likes2
  Actions

Approval CompletedBy information is not correct in email body

Outcomes

Related Content

Recommended Content

Incoming Links