How to check (as admin) which users read a new document

[Pitt]

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)

[jllort]

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 )

[Pitt]

Thank you!

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

[jllort]

I suggest starting with a simple SQL like:

Code: Select all

select * from OKM_ACTIVITY limi 10;

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.