AnsweredAssumed Answered

How can we fetch Individual Change Item details in SQL Node in Workflow.

Question asked by Hemant Mandle on Aug 29, 2017
Latest reply on Aug 30, 2017 by Hemant Mandle

Like • Show 0 Likes0
Comment • 6

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

Hemant Mandle Aug 30, 2017 3:31 PM

Correct Answer

All, I was able to archive it using default configuration available in Workflow. So closing this thread.

Thanks

Hemant.

See the reply in context

No one else had this question

Outcomes

6 Replies

Muneendra Sriram Aug 30, 2017 7:49 AM
Mark Correct
Correct Answer
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
Like • Show 0 Likes0
Actions
- Hemant Mandle @ Muneendra Sriram on Aug 30, 2017 10:49 AM
  Mark Correct
  Correct Answer
  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.
  Like • Show 0 Likes0
  Actions
Olivier Cheron Aug 30, 2017 10:04 AM
Mark Correct
Correct Answer
Isn't this already available in variables like the following?
```
${access_request_cri_app_name}
${access_request_cri_grp_name}
```
Like • Show 1 Like1
Actions
Hemant Mandle Aug 30, 2017 10:50 AM
Mark Correct
Correct Answer
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.
Like • Show 0 Likes0
Actions
- Olivier Cheron @ Hemant Mandle on Aug 30, 2017 11:24 AM
  Mark Correct
  Correct Answer
  You can query public views joining like this:
  PV_CHANGE_REQUEST_ACTIVITY lists items involved in change request activities, and give you WORKITEM_ID
  then PV_CHANGE_REQUEST_WORK_USER lists users associated with the work items
  and PV_USERS, if you need more information about approvers
  Like • Show 0 Likes0
  Actions
Hemant Mandle Aug 30, 2017 3:31 PM
Unmark Correct
Correct Answer
All, I was able to archive it using default configuration available in Workflow. So closing this thread.

Thanks
Hemant.
Like • Show 0 Likes0
Actions

How can we fetch Individual Change Item details in SQL Node in Workflow.

Outcomes

Related Content

Recommended Content