Forum Discussion

PerBonomi's avatar
PerBonomi
Boss
10 years ago

Did current user kudo this post?

Hi there, I'm trying to use the API to find out if the current user already kudoed a post. I know how to find the list of users who have kudoed a post, but some of our posts have 5000+ kudos (we don...
OlivierS's avatar
OlivierS
Lithium Alumni (Retired)
10 years ago

PerBonomi the problem is you can't use the AND operator in the WHERE clause for the kudo resource ...

 

So it's either:

 

SELECT * FROM kudos WHERE message.id='187'

 or:

 

SELECT * FROM kudos WHERE user.id = '2'

 plus a loop in the results ...

 

I can't think of anything more straight forward. Maybe other will do ...