
How do I approach showing likes count on a post ?
I have created a database which has the userID of the users who liked .
How do i show the number ?
I also wanna have a special “Top Liked” tag if the post has over 1,000 likes .
Is this done via functions or is there a way to do it via Databases ?

hey @Thatguyx! I believe to show the likes count, you can just query your likes
collection where you store the userIDs. Then, count how many userIDs are linked to that post. Like this:
const likedPost = await database.listDocuments('likesCollection', [
Query.equal('postId', postId)
]);
const likeCount = likedPost.documents.length;
and for the "Top Liked" tag, you can just check if the likeCount
is over 1,000, and if it is, you can set that tag:
let tag = '';
if (likeCount > 1000) {
tag = 'Top Liked';
}
umm, also, if you want to automate this (like updating the tag when it hits 1,000 likes), you could use an Appwrite function, but honestly, the database and a little logic in your app should do the trick. ^^
lmk if it works or if you need further help : )
Recommended threads
- Golang docs outdated
Golang docs on the website are update and some if not all methods are broken/ not updated
- Problem with login using Retool
I am using the Appwrite rest api to create an email session from Retool. My next api call is to create JWT. The call is failing because Retool is a closed envir...
- Adding Attributes to User
What is the best way to add attributes for a User? Do I need to create another entity with the attributes since I cant add them in the Auth service. Thx
