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/me...
  • 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.

     

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.

 

  • vedagarw's avatar
    vedagarw
    Guide
    8 years ago

    This works !! Thanks