Forum Discussion

erickwang's avatar
erickwang
Contributor
6 years ago

How to get the total number of many kinds of views for a unique user? IE. Topic View...

How can I get the total topic number and total reply number for a unique user? May I get help from some one that how can I get the numbers of some kinds of views for a unique user? I want to get the...
VikasB's avatar
VikasB
Boss
6 years ago

erickwang 
For topic count 

SELECT count(*) FROM messages where author.id = '7' and depth = 0

For reply count

SELECT count(*) FROM messages where author.id = '7' and depth > 0

But unfortunately, there is no API to get the view count for a specific user. 

  • erickwang's avatar
    erickwang
    Contributor
    6 years ago

    Thanks for your quick reply. If we don't get the view count for a specific user, can we get the total number of Board View, Topic View, Accepted Solution View, Article View, Idea View, Blog Read and Comment for all the user? 

    • VikasB's avatar
      VikasB
      Boss
      6 years ago

      erickwang 

      For board/blogs/idea view count

       

      SELECT views FROM boards where id = 'B1'

       

      Read count for all messages 

       

      community.lithium.com/community-name/restapi/vc/boards/id/[id]/messages/read/count

       

       Messages/article view count

       

      communtiy.lithium.com/community-name/restapi/vc/messages/id/[id]/views/count

       

      read count

       

      community.lithium.com/community-name/restapi/vc/threads/id/[id]/messages/read/count

       

      Hope these APIs will help you. 

      • erickwang's avatar
        erickwang
        Contributor
        6 years ago

        I attached an screenshot. May I know how can I get these information?

        request.png