Finance | Project Operations, Human Resources, ...

I want the query statement that is executed on SQL get WorkFlow History in F & O

(2) Share

Report

Posted on by CU09091051-0

322

I need an SQL query to retrieve the Purchase Requisition>>Workflow History in Dynamics 365 Finance & Operations. Specifically, I want to extract the data from the 'Tracking details list' tab in the Workflow History screen to generate a report.

Purchase Requisition: 000031

Of course, I want the query sentence according to the number Purchase Requisition: 000031

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

CU07021417-0 2 on at

Like (0)

Report
Copy link

Link copied!

select firstonly from 'tablename' where 'tablename'.'field' == 000031;

Was this reply helpful? Yes No
CU09091051-0 322 on at

Like (0)

Report
Copy link

Link copied!

Thank you Mr. "CU07021417-0" for the reply, but unfortunately this is not the solution.... The data source for the "Tracking Deliles List" tab is the "" table "WorkflowStatusTrackingTmp" and when I query "Select * from WorkflowStatusTrackingTmp" it gives me that the table does not exist

What is the table that contains the "Tracking Deliles List" movements"" and is linked to the main "WorkflowTrackingStatusTable "table؟؟؟؟؟؟

Was this reply helpful? Yes No
Suggested answer

Justin Kruger 186 on at

Like (0)

Report
Copy link

Link copied!

Hi,

The two tables you are looking for is WorkflowTrackingStastusTable and WorkflowTrackingTable

Try this query:

select * from WORKFLOWTRACKINGSTATUSTABLE WTST
join WorkflowTrackingTable WTT on WTT.WORKFLOWTRACKINGSTATUSTABLE = WTST.RECID
where WTST.INSTANCENUMBER = '000846'

Was this reply helpful? Yes No
Suggested answer

Aymen CHELBI 620 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Try this query :

SELECT
pr.PurchReqID, -- Purchase Requisition ID
wf.WorkflowInstance, -- Workflow Instance ID
wf.TrackingNumber, -- Workflow Tracking Number
wf.WorkItemType, -- Work Item Type
wf.Status, -- Workflow Status
wf.CompletedDateTime, -- Completion Date and Time
wf.CreatedDateTime, -- Created Date and Time
wf.UserName, -- User who performed the action
wt.WorkflowTypeName, -- Workflow Type Name
wt.Description AS WorkflowDescription, -- Workflow Description
wf.ActionName, -- Action Taken in Workflow
wf.Note -- Notes/Comments in the Workflow
FROM

PurchReqTable pr
JOIN
WorkflowHistory wf
ON pr.PurchReqID = wf.PurchReqID
JOIN
WorkflowTrackingDetails wt
ON wf.WorkflowInstance = wt.WorkflowInstance
WHERE
pr.PurchReqID = '000031' -- Specific Purchase Requisition
ORDER BY
wf.CompletedDateTime DESC; -- Sort by Date for chronological order

Was this reply helpful? Yes No