Forum Discussion

keithkelly's avatar
keithkelly
Leader
2 years ago

API Help: Recent Topics (but only for subscribed boards?)

Our external beta users have requested a Recent Discussions module on the home page, but filtered to only discussions within their subscribed areas.  I realize a My Subscriptions panel exists, but I...
API
luk's avatar
luk
Boss
2 years ago

I'd basically filter subscriptions by target.type = 'board' for the current user and get the the relevant board id's from that query, e.g.:

SELECT target.id FROM subscriptions WHERE target.type = 'board'

 

loop through the response items and assemble the board id's in a sequence.

then use that board id sequence in the next query to get the topics from the subscribed boards:

 

"SELECT subject, view_href, conversation FROM messages WHERE board.id IN('" + boardids?join("', '") + "') AND depth = 0 ORDER BY conversation.last_posting_activity_time DESC LIMIT 100"