Exporting data from K2 Five workflow report

[Renuka]

Hi all

is there a way we can export data from workflow report to excel?

Please advise.

Thanks

[SarelL · Accepted solution]

Hi @Renuka 

You can use the Workflow reporting SMO's in the System folder. Create a listview and add the excel export control. 

you can add then your own filters etc... 

Kind Regards

Sarel

[Renuka]

Hi @SarelL 

I can see this SMO in management but not in designer. Is this folder hidden?

would you please advise.

Thanks

[khanh]

Hi Renuka,

There is Show: (All) at the bottom left corner of the Designer, you can click the (All) link and enable the System checkbox, this will enable System category in the Designer.

[Renuka]

thanks you for your help @khanh @SarelL 

Would you know which table to look at on K2 DB for data?

thanks

[SarelL]

Please dont use the k2 DB, the SMO is already available for you. Screenshot attached. 

Regards

Sarel

[Renuka]

Hi @SarelL 

User is wanting to have a live connection for reporting purposes. I am thinking to create a reporting view for the user using table.

Thanks

[SarelL]

Good Morning,

You will be able to do that by using the Server.ProcInt/ProcData etc tables, but this is not adviceable so please don't mark this as a solution rather mark the K2 out of the box SMO, the K2 SMO that is there for you will also be Live connection/ real time data like a SQL View will be.

Its your choice but K2 has already put all information and join statements etc together for you.

Regards
Sarel

[khanh]

Hi SarelL,

It sounds like what you guys need is the K2 Odata Feed, I would avoid direct querying the K2 database.

https://help.nintex.com/en-US/k2five/userguide/5.5/default.htm#How-Tos/ODataFeedService/ODataFeedWit...

[Renuka]

hi @khanh 

WF Smo gives all the WF instances that I dont want to expose to user. Is there a way we can filter this per workflow?