
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
- NIOHTTPCompression-Error
Hi, I have self-hosted Appwrite via Coolify on a Ubuntu-VPS . I am accessing the Database via Swift. Everything is working as expected, but with one collection ...
- Custom Domain
I’m trying to add a custom domain. I added the nameservers like shown for kassa.velleb.com I always get this error, ive waited for a day now and ive checked dns...
- Bulk Update Error
Getting Following error when updating a document: ``` Failed to Update User: Bulk update is not supported for collections with relationship attributes. ``` In...
