Featured post from specific query
Hi developer community, I'm trying to get featured post from a specific category and its ancestors. This is the query I'm using the below: SELECT id, kudos.sum(weight), post_time, conversation....
Forum Discussion
Hi Isateesh,
Please try the following LIQL Query:
SELECT id, kudos.sum(weight), post_time, conversation.featured, metrics.views, conversation.messages_count, view_href, topic.subject, kudos FROM messages WHERE category.id = '${id}' and conversation.featured = true AND depth=0 Order By conversation.featured ASC LIMIT 9
Thanks for quick pick Payal, will try and let you know.
