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
      • JakeR's avatar
        JakeR
        Khoros Alumni (Retired)
        7 years ago

        If I am not mistaken, I believe this page contains all of the fields that can be used for the data that is available in a profile.  You should be able to construct the appropriate Calls from the content shared in that article, given what VikasB has shared so far.

        Please let me know if this helps.

        Sign in to react to this post