Hi @Akuner 

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

Hi @SarelL 

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

would you please advise.

Thanks

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.

thanks you for your help @khanh @SarelL 

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

thanks

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

Regards

Sarel

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

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/ODataFeedWithExcel.htm?Highlight=odata

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?

Hi @SarelL 

The problem with the view is user is having to export data and we want to be able to create a live data instance for the user.