Page 1 of 1

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

PostPosted:Wed Sep 20, 2023 10:43 am
by 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)

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

PostPosted:Tue Sep 26, 2023 7:25 am
by 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 )

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

PostPosted:Tue Sep 26, 2023 5:18 pm
by 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?

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

PostPosted:Tue Oct 17, 2023 2:06 pm
by 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.