As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
Hi Everyone,
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.
