AnsweredAssumed Answered

Most Viewed and Liked Documents in alfresco

Question asked by sandeepreddy1 on Mar 22, 2018
Latest reply on Mar 23, 2018 by krutik.jayswal

Hi Everyone,

By using this query i am getting document creator and created date

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 and liked documents in alfresco, can anyone help out me please.

Like (0)  Reply Actions 

Outcomes