Forum Discussion

arthur_'s avatar
arthur_
Guide
7 years ago

Number of posts inside category or board

Hi,   We are trying to extract the number of messages inside board/category on CategoryPage.NodeList page using the following queries:   SELECT messages.count(*) FROM boards WHERE id = 'board_ID'...
  • TariqHussain's avatar
    TariqHussain
    7 years ago

    arthur_-

     

    If the native components show there is something inside when its empty actually, it is due to cache or indexing issue.

    You need to clear cache and check, if this doesn't solve the issue, open a ticket with lithium support for clear the cache and re-index the board data.

     

     

     

     

TariqHussain's avatar
TariqHussain
Boss

arthur_ -

Could you please try to count messages for boards with API V1 also and confirm if you are getting same result (zero for some boards) 

arthur_'s avatar
arthur_
Guide
7 years ago

TariqHussain Thank you very much for the suggestion.

 

Tried to use API V1 using the following queries

 

/restapi/vc/boards/id/board_ID/messages/count
/restapi/vc/categories/id/category_ID/posts/count

 

If API V2 call returned 0 for board in question, API V1 call returned the same value as native CategoryPage.NodeList component showing that something is inside (although that board is empty).

 

API V1 call returned the same value as API V2 call when applied to categories, but unfortunately in both cases the value didn't match the native component.

  • TariqHussain's avatar
    TariqHussain
    Boss
    7 years ago

    arthur_-

     

    If the native components show there is something inside when its empty actually, it is due to cache or indexing issue.

    You need to clear cache and check, if this doesn't solve the issue, open a ticket with lithium support for clear the cache and re-index the board data.

     

     

     

     

    • arthur_'s avatar
      arthur_
      Guide
      7 years ago

      TariqHussain

       

      Thank you very much for your suggestion, we will try to approach lithium's support. 

       

      Unfortunately, clearing cache didn't solve the issue.