Is there a way to track likes (or have all liked pages show up in a table - with who liked them)?

[Daniel Samuels]

Hi,

Does anyone know a way to track all liked pages? If possible I would like all liked pages to show up in a table with who liked them and when.

I have a feeling I may be able to use the SQL Query Macro to do this, but I just dont know enough about the inner workings of Confluence to set this up myself.

Any help would be greatly appreciated.

Thanks,

Daniel

[PeterKoczan · Accepted solution]

Hi Daniel,

Actually you are on the right track. The query should be as easy as querying the LIKES table.

It has 4 columns, where contentid refers to the contentid column in the CONTENT table, username is self-explanatory and you have a creationdate to indicate the time of liking.

So for example this query would return all pages liked ordered by the number of likes:

select c.title,count(l.*) as likes from LIKES l, CONTENT c where c.contentid=l.contentid group by c.title order by count(l.*);

Kind regards,

Peter

[Daniel Samuels]

Hi Peter,

Thanks so much! This is exactly what I was trying to do.

Best,

Daniel

[Daniel Samuels]

Hi Peter,

Thanks so much! This is exactly what I was trying to do.

Best,

Daniel

[ABR]

Hi! 

I've never used the SQL Query Macro and cannot find it on my macro list. could you please help me find it?

I need to do exactly what Daniel needed to do, a lot is depending on it.