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

 

  • ChhamaJ's avatar
    ChhamaJ
    Khoros Staff
    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

     

    • santosh_csc's avatar
      santosh_csc
      Guide
      8 years ago
      Select conversation.count(*) from messages where board.id = 'tp' and depth=0 should work right?
      • VikasB's avatar
        VikasB
        Boss
        8 years ago

        Hi santosh_csc can I know what you want to get?

        I think you are trying to get the topics or message count excluding replies. If yes, you can use below API

         

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