Hi community!
I'm thinking of creating a top-viewed posts component for our forums (to place on each board's home page and perhaps also on the right rail of individual thread pages; could be top-viewed all time or top-viewed last 30 days), but I'm not quite sure how to do it. Before I dive in, I am wondering if any of you have built such a thing and would care to share your code or give me some pointers.
Thanks!
CarolineS - Required something similar functionality, however, there is no API call which can filter post by views for one month. You can get posts created within last month and filter by page views.
Thanks, TariqHussain! Do you happen to have the code for that? I imagine I could figure it out, but if you've already done it.... 😉
Threads top viewed all the time.
SELECT * FROM messages where depth = 0 ORDER BY metrics.views DESC
For threads posted in one month and sorted by most views
SELECT * FROM messages where post_time > timestamp AND depth = 0 ORDER BY metrics.views DESC
The timestamp will for 30 days before time.
As I mentioned above this will give you messages which is posted within last month and sorted by date views. But not get message top viewed in last 30 days (could be posted before 30 days but viewed most in last 30 days)
Documentation: https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collection=messages#constraints-post_time
