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.