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

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

      • JakeR's avatar
        JakeR
        Khoros Oracle
        6 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.