I need to show most viewed documents and most liked documents in alfresco from the alfresco database.
can anyone help out please
Sorry, Is this question related to ADF framework?
I believe it is not.
I am going to move it into the Content Service forum.
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.
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.
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.
Retrieving data ...