Microsoft Dynamics AX (Archived)

Workflow - Get Escalated To and Reassigned To User Name

(0) Share

Report

Posted on by Rahul_sinha

112

Hi Everyone,

My requirement is to get Workflow Escalated To and Reassigned To User name from Workflow.

Description :

Suppose i have one workflow X. When we see the tracking details we can see that it has been escalated from User A to User B.

I need to get the value of User B through X++ coding as i need it to display it on the report.

Kindly help anyone with the code snippets if any.

Or from which table i can fetch the value of User B.

Same goes with the case of Reassigned To

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (1)

Suggested answer

guk1964 10,888 on at

Like (0)

Report

You can set up alert notifications by email for Event, and that includes escalation.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Have you checked the standard workflow history report/form?

Doesn't this one fulfill your requirement already?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Khushhal Garg 1,514 on at

Like (0)

Report

Look at Workflow* tables and you can retrieve User B from these tables.

Was this reply helpful? Yes No
Suggested answer

Riswan 107 on at

Like (0)

Report

Hi Rahul,

It's WorkflowWorkItemTable. You can filter by pending status for User B.

Regards,

Riswan.

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report
I agree with Riswan , It would be workflowWorkItemtable . Following sample query might help you to get some idea to retrieve records you want. The below query is for retrieving pending vendor invoice approval workflow but you can write your own as per requirement.

WorkflowWorkItemTable workItem;

while select crosscompany Num, InvoiceAccount, CreatedDateTime, DataAreaId from invoice where invoice.RequestStatus == VendInvoiceRequestStatus::InReview join UserId, CreatedDateTime from workItem where workItem.RefTableId == invoice.TableId && workItem.RefRecId == invoice.RecId && workItem.Type == WorkflowWorkItemType::WorkItem && workItem.Status == WorkflowWorkItemStatus::Pending

Was this reply helpful? Yes No
Rahul_sinha 112 on at

Like (0)

Report

@Ludwig Reinhard
[quote user="Ludwig Reinhard"]
Hi,

Have you checked the standard workflow history report/form?

Doesn't this one fulfill your requirement already?

Best regards,

Ludwig
[/quote]
Yes, i have checked the standard workflow history report/form, but the fields only showcase the data for "Escalated by" and "Reassigned by" which i found in the table "WorkflowWorkItemTable" but "Escalated to" and "Reassigned to" is not present in any workflow system tables.

Was this reply helpful? Yes No
Rahul_sinha 112 on at

Like (0)

Report

@Riswan I tried but this doesn't worked. Any other way?

Was this reply helpful? Yes No
Rahul_sinha 112 on at

Like (0)

Report

@Sukrut Parab I have used this code for "Escalated by" and "Reassigned by" and "Last action taken by", but for former "Escalated To" and "Reassigned to" does not fulfill this code criteria. Any other suggestions?

Was this reply helpful? Yes No
Verified answer

Riswan 107 on at

Like (0)

Report

Hi Rahul,

In the same table,

1. There is a field called type, if you filter by Escalated for User B you can achieve the ESCALATION TO scenario.

2. There is a field called status, if you filter by Delegated for User B you can achieve the REASSIGNED TO scenario.

Regards,

Riswan.

Was this reply helpful? Yes No
Rahul_sinha 112 on at

Like (0)

Report

@Riswan Thanks a lot. I got Escalation To value correctly.

Can you Please tell me how to find "Last Action Taken by Value"

I have written this code, but it seems to be not working fine. Please review and let me know the correct code snippets.

Was this reply helpful? Yes No