Forum Discussion

isateesh's avatar
isateesh
Contributor
7 years ago

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....
Payal's avatar
Payal
Director
7 years ago

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