ConradMc
Contributor

SmartObject OData API - Workflow Error Date

Jump to solution

Hi,

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: 

ab1dd365-3e70-44b6-b271-4a50a7867749.png

 

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

f82ac0c5-2c74-4c79-bbeb-bc5a39b5bb26.png

 

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.

 

Thanks

 

 

Tags (3)
0 Kudos
Reply
1 Reply
ConradMc
Contributor

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
Reply