Forum Discussion

erickwang's avatar
erickwang
Contributor
7 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...
Views
Sign in to react to this post
VikasB's avatar
VikasB
Boss
7 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. 

Sign in to react to this post
  • erickwang's avatar
    erickwang
    Contributor
    7 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? 

    Sign in to react to this post
    • VikasB's avatar
      VikasB
      Boss
      7 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. 

      Sign in to react to this post
      • erickwang's avatar
        erickwang
        Contributor
        7 years ago

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

        request.png

        Sign in to react to this post