Get Work Order Lifecycle Log for All Work Orders

(0) Share

Report

Posted on by JordanM1

Hi,

For each work order in D365 FO I would like to get access to the previous work order lifecycle states and when they started/ended.

The purpose is to visualize the data in PowerBI to understand the duration each work order spent at each stage.

I am able to see the lifecycle state log through the browser (see screenshot) by going to "All work orders" > click a work order > "Lifecycle State Log".

Does any one know what table this data is stored in? Can I access this through oData?

0257.d365.PNG

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

huijij 19,811 on at

Like (0)

Report

Hi JordanM1,

The form data is from the table StateLog (EntAssetLifecycleStateLog).This entity does not currently exist, but you can check the MS document to build an entity,expose and consume an entity for OData.

learn.microsoft.com/.../build-consuming-data-entities

Was this reply helpful? Yes No