SmartObject OData API - Workflow Error Date

Jump to solution


We are creating our own K2 Performance Power BI Report. We are using K2’s Power BI report as a template.

At a high level, I am currently trying to put together a line chart displaying workflow errors. However, I am having a problem trying to obtain the Error Date of a Process Instance.


It is displayed within K2 Management: 



However I cannot identify the field within any of K2’s built-in Workflow Analytic SmartObjects:



I come across is the finish date field, but this is only set when a Process has a status of Completed or Deleted.

What I need is simply the error date for all Processes with a status of Error.


If anyone has could help, that would be great.





Tags (3)
0 Kudos
1 Reply

Re: SmartObject OData API - Workflow Error Date

Jump to solution

Update: I worked out how to do this in the end. I will share incase anyone else interested. 

At a very high level,

  1. Filter on the following:
  • Activity Instance table: Status is Completed
  • Process Instance table: Status is Error or Stopped
  1. Then the error date is:
  • Activity Instance table: Finished Date