SmartObject OData API - Workflow Error Date

  • 11 December 2020
  • 1 reply
  • 1 view


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.






Best answer by ConradMc 18 December 2020, 14:48

View original

1 reply

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