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?