Forum Discussion

mrkevanlin's avatar
7 years ago

API call for getting the count of authored solutions per a specific board?

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!

  • mrkevanlin

    USe this one

    SELECT * FROM messages WHERE author.id = 'id' AND is_solution = true and board.id='id'
  • mrkevanlin

    USe this one

    SELECT * FROM messages WHERE author.id = 'id' AND is_solution = true and board.id='id'