Solved
Forum Discussion
1 Reply
USe this one
SELECT * FROM messages WHERE author.id = 'id' AND is_solution = true and board.id='id'
Sign in to react to this post
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'