search cancel

Get the approver ID of a create user task via PX

book

Article ID: 229277

calendar_today

Updated On:

Products

CA Identity Suite CA Identity Manager

Issue/Introduction

Scenario:

There is a requirement to retrieve the User ID for an approver from a Workflow action via PX (Policy Xpress), can this be achieved?

Environment

Release : 14.x

Component : Identity Manager

Resolution

Policy xPress Events tab:

Policy xPress Data Tab:

  1. getUserID

2. get tasksessionid (containing Workflow Activity ID) for the specific getUserID value:

SELECT [tasksessionid]   FROM [idmstore].[dbo].[event12_5]   where [description] like '%{'getUserID'}%' and tasksessionid like '%:WPDS%'

  1. get the index / start position of “:WPDS” string in the data returned in Data variable 2 above, tasksessionid

  1. Get the position of the search “|” in tasksessionid (data variable #2):

  1. Calculate WPDS Activity ID start position in the tasksessionid string:

  1. Extract WPDS ID from tasksessionid obtained in Data variable #2 above.

  1. Get Approver Name for your task:

SELECT [LU_ID]  FROM [idmstore].[dbo].[WP_ACTI_DATA] where [ACTI_ID] = '{'getWPDSID'}' AND [VAR_NAME]= 'ACTION_PERFORMED'

  1. Get Approval Status for your request (whether it was approved or rejected):

SELECT [VAR_VALUE] FROM [idmstore].[dbo].[WP_ACTI_DATA] where [ACTI_ID] = '{'getWPDSID'}' AND [VAR_NAME]= 'ACTION_PERFORMED'

 

 

Attachments