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

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?