Forum Discussion

vedagarw's avatar
vedagarw
Guide
9 years ago

LIQL Query to retrive posts from all boards in a parent category

Hi,

I have a community structure like this.

 

Parent Category 1

--- Child Board 1

--- Child Board 2

Parent Category 2

-- Child Board 3

-- Child Board 4

 

I want to retrieve all the posts/message from boards of Parent Category 1 and also get the kudo count with the corresponding message. How can I achieve this ??

 

 

  • TariqHussain's avatar
    TariqHussain
    9 years ago

    vedagarw -

    Following query will return all the messages from "Parent Category 1" with kudos.

    select kudos.sum(weight),body,subject from messages where category.id = 'Parent Category 1'

    Give kudos if you find my posts helpful or mark solution if it answers your query.

     

2 Replies

Sort By
  • TariqHussain's avatar
    TariqHussain
    Boss
    9 years ago

    vedagarw -

    Following query will return all the messages from "Parent Category 1" with kudos.

    select kudos.sum(weight),body,subject from messages where category.id = 'Parent Category 1'

    Give kudos if you find my posts helpful or mark solution if it answers your query.