Get list of Users who liked a page.

Question

Hi,

i have a Confluence Page that got liked by over 100 Users. When i click "show who liked this page" it only shows me around 40 Users. How can i get a coomplete list of all the Users who liked this page?

Brant Schroeder · Accepted Answer

You will have to use SQL or the API to get this information.  I believe the SQL would be this.

select c.title, l.username from LIKES l, CONTENT c where l.contentid = 'YOUR PAGE ID HERE'