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

320

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)

Suggested answer

CU07021417-0 2 on at

Like (0)

Report

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

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

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

Like (0)

Report

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

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 183 on at

Like (0)

Report

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

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 376 on at

Like (0)

Report

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

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

Join the conversation

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates