Open Source Document Management System | OpenKM

Hello,
I insert a new document or edit a document. After that, users should see in their dashboard, that there is a new or edited document.
After that, I want (as admin) to check after a few days, who (which users) read this new document, because I need the possibility, to document, who has really taken notice of this editing or new document.

How can I realise that?

Thx!

Pitt (OpenKM community edition 6.3)

Better to plan this kind of feature as a weekly report indicating the created or updated documents and who has read or edited them. You can create this kind of report as an SQL for table OKM_ACTIVITY.

You should take control of some events : https://docs.openkm.com/kcenter/view/ok ... entactions
CHECKIN_DOCUMENT -> edition
GET_DOCUMENT_CONTENT or GET_DOCUMENT_CONTENT_BY_VERSION ( when previewing or downloading the document )

Thank you!

It sounds not very easy to realise this
Shall I use iReport?
Where can I find an examble of a sql report?

I suggest starting with a simple SQL like: When you understand the data collected there, should be quite easy to build a report.

You have some reports at https://docs.openkm.com/kcenter/view/ok ... -pack.html that maybe used as a starting point.

Is there a document where I can see the whole database structure of openkm CE? (Tables and relations)
Because I have problems to find the right SQL query for my task.

In this section of the documentation are described the main tables https://docs.openkm.com/kcenter/view/ok ... ption.html ( the most relevant things are in these tables, others are not so relevant )