Forum Discussion

vedagarw's avatar
vedagarw
Guide
10 years ago
Solved

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
    10 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
10 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
10 years ago

This works !! Thanks