Forum Discussion
1 Reply
Sort By
USe this one
SELECT * FROM messages WHERE author.id = 'id' AND is_solution = true and board.id='id'
Related Content
- 11 months ago
- 3 years ago
- 2 years ago
- 3 years ago
Looking to see if it's possible to look up one person's authored solutions within the context of one board, not the whole community. Something like:
search?q=SELECT solutions_authored.count(*) FROM users WHERE id = 'XXXX' AND boards WHERE id = 'board-name'
This is obviously throwing back an error. Thanks!
USe this one
SELECT * FROM messages WHERE author.id = 'id' AND is_solution = true and board.id='id'
USe this one
SELECT * FROM messages WHERE author.id = 'id' AND is_solution = true and board.id='id'