Kilfaxi
7 years agoContributor
Sum kudos for all messages in a specific board using Community API V2
I imagine there must be a way to do this. The query that I want to get to work would look as follows: SELECT message.id, user.email, kudos.sum(weight)
FROM messages
WHERE board.id = 'ABC' And what...
- 7 years ago
The query below worked.
It appears that user.email is invalid (author.email instead), and message.id is also invalid (id instead).
Finally, adding depth = 0 just makes the results set a bit cleaner.
SELECT author.email, id, kudos.sum(weight) FROM messages WHERE board.id='ABC' AND depth = 0
Im still not understanding why there is a user object referenced within messages, but you cannot do user.email, etc.