Forum Discussion

isateesh's avatar
isateesh
Contributor
8 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....
Views
Sign in to react to this post
Payal's avatar
Payal
Director
8 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

Sign in to react to this post
  • isateesh's avatar
    isateesh
    Contributor
    8 years ago
    Thanks for quick pick Payal, will try and let you know.


    Sign in to react to this post