Custom K2 Reporting | Community

What are the options for custom reporting against K2 data and Application DB data?

Obviously you can go through K2ROM but there are user access issues

Is it supported to do read only queries off the K2Log DB

Any other options?

thanks

Page 1 / 1

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,

Reply