Forum Discussion

vbandi's avatar
vbandi
Contributor
9 years ago

Get replies counts along with Topic

Hi All,   I was trying to get count of replies  along with Root Topic. (Or count of child items when i am trying to retrieve parent)   For example :- To get root Topic i have used LiQL as below...
  • ChhamaJ's avatar
    ChhamaJ
    9 years ago

    Hi vbandi,

     

    You cannot combine  '*' and any other field in the LiQL query. If you need to get replies.count(*) along with other fields then you will have to specify all the fields individually.  For example, 

    Select id, board, subject, author, replies.count(*) from messages where board.id = 'tp' and depth=0

    In the above query, add all the fields that you need to be returned.

     

    Hope this helps.

     

    Regards,
    Chhama

     

VarunGrazitti's avatar
VarunGrazitti
Boss

vbandi - Remove the depth = 0

 

http://test/api/2.0/search?q=SELECT+*+FROM+messages+WHERE+board.id= 'tp' +AND+and+conversation.style='forum'+LIMIT+20+OFFSET+0

 

I hope this helps.

vbandi's avatar
vbandi
Contributor
9 years ago

thanks a lot for the reply VarunGrazitti

 I wanted to have some thing like this

 

http://test/api/2.0/search?q=SELECT+* , replies.count(*) +FROM+messages+WHERE+board.id= 'tp' +AND+depth=0+and+conversation.style='forum'+LIMIT+20+OFFSET+0

 

The intention of having this query is to get root topic and get count of child topics under it to display it to user.

 

I think VarunGrazitti, the query u mentioned might not be helpful to get the required result.

.

 

Thanks,

Vijay