Dear Community,
are there any components available to show the most popular articles / blogs / posts based on views or clicks?
We’d like to show the top 3 (most clicked) blog articles on our startpage. Do you have any recommendations how we can implement this?
thank you, best regards,
Clemens
clemensw- You need to add conversation.style as well.
SELECT * FROM messages where conversation.style='blog' ORDER BY metrics.views DESC limit 3
You can use below API to implement the custom component.
SELECT * FROM messages ORDER BY metrics.views DESC limit 3
This will bring the top 3 messages with most views.
Documentation: https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collection=messages
thank you - the query lists also forum articles and posts.
How can I select blog articles only ?
Thank's
clemensw- You need to add conversation.style as well.
SELECT * FROM messages where conversation.style='blog' ORDER BY metrics.views DESC limit 3
