topic Re: Most viewed documents and most liked documents in alfresco in Alfresco Forum

Most viewed documents and most liked documents in alfresco

sandeepreddy1 — Wed, 21 Mar 2018 12:54:48 GMT

Hi Everyone,I need to show most viewed documents and most liked documents in alfresco from the alfresco database.can anyone help out please

Re: Most viewed documents and most liked documents in alfresco

eugenio_romano — Wed, 21 Mar 2018 13:56:30 GMT

Sorry, Is this question related to ADF framework?

Re: Most viewed documents and most liked documents in alfresco

douglascrp — Wed, 21 Mar 2018 20:16:51 GMT

I believe it is not.

I am going to move it into the Content Service forum.

Re: Most viewed documents and most liked documents in alfresco

douglascrp — Wed, 21 Mar 2018 20:17:43 GMT

You could use a solution like the following to generate those kinds of reports

GitHub - fcorti/Alflytics: The Open Source Business Intelligence solution over the Alfresco platform.

Re: Most viewed documents and most liked documents in alfresco

sandeepreddy1 — Thu, 22 Mar 2018 07:03:34 GMT

Hi Douglas C. R. Paes ,

i need to see from alfresco(Postgresql) database, can you please suggest me database query for most viewed documents in alfresco.

Re: Most viewed documents and most liked documents in alfresco

sandeepreddy1 — Thu, 22 Mar 2018 08:35:34 GMT

Hi Everyone,

By using this query

SELECT distinct n.audit_creator as creator,p.string_value as document_name,date(n.audit_created) as created_on
From alf_node AS n,alf_qname AS q,alf_node_properties as p
WHERE n.type_qname_id=q.id AND p.node_id=n.id AND p.qname_id IN (SELECT id FROM alf_qname WHERE local_name='name')
AND n.audit_creator not in('admin') AND n.audit_creator not in('System') AND q.local_name='content' AND p.string_value NOT LIKE '%.xml' order by created_on ASC;

i am getting like this

creator | document_name | created_on
----------+--------------------------+------------
Sandeep | Alfresco_User_Guide.docx | 2018-03-20
(1 row)

Like this i need to show list of most viewed documents in alfresco, can anyone help me please.