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

 

---

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

---

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.

---