Hello All
I want to fetch individual change item detail (Application Name, and Group) in Approval workflow, where below setting is On
is it possible to fetch it using SQL?
Thanks
Hemant
Hello All
I want to fetch individual change item detail (Application Name, and Group) in Approval workflow, where below setting is On
is it possible to fetch it using SQL?
Thanks
Hemant
Hi Hemant,
Please try below query in SQL select node. This query will fetch the Entitlement type as group only.
select distinct g.name as Group1,a.name as "Application_name" from PV_USER_GROUP g
join PV_APPLICATION a on a.id=g.application_id
where g.id in (select value_id from pv_change_request_activity where
change_request_id=${access_request_requestID} and workitem_id='${jobUserData_acm.workitem}' and WORK_STATE='Available' and value_type='UserGroup')
Regards,
Muneendra
Hello Muneendra
Thanks for your reply!
What I am trying to achieve is bit different, let me explain in detail :
Let say I added 2 different entitlements to Role (Active Directory and Unix), and my workflow has setting to create individual job for each entitlement owner. So when Approval get generated for Approver, I want to fetch Application Name for that Approver only, so I can do some automation there.
Currently, when I extract data using change request, it is returning me both application data, and which is not I want.
Thanks
Hemant.
Hello Olivier,
Yes, it is available in workflow. My requirement is for individual item where multiple application entitlements has been added to role. How can I know which approver is approving which application?
Thanks
Hemant.
All, I was able to archive it using default configuration available in Workflow. So closing this thread.
Thanks
Hemant.