Custom K2 Reporting

Yes, that is one of the main reasons for the existence of the K2Log db. You are allowed to do read only queries on the K2Log db.

Regards,
Ockert

thanks, is there any help on the data model or sql queries or is it a matter of figuring the data structures out yourself.

thanks

You can contact your local K2 support office for a copy of the K2Log ERD document. This is a draft document explaining the table layouts. What I normally do is to run a SQL trace on the K2Log db and then run a specific K2Workspace report which returns more or less the same data that I need. I then use this query as a starting point.

Regards,