Forum Discussion

clemensw's avatar
clemensw
Guide
7 years ago

How to show popular blog article (most views)?

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 startp...
  • TariqHussain's avatar
    TariqHussain
    7 years ago

    clemensw- You need to add conversation.style as well.

    SELECT * FROM messages where conversation.style='blog' ORDER BY metrics.views DESC limit 3
clemensw's avatar
clemensw
Guide

TariqHussain

thank you - the query lists also forum articles and posts.
How can I select blog articles only ?

Thank's

TariqHussain's avatar
TariqHussain
Boss
7 years ago

clemensw- You need to add conversation.style as well.

SELECT * FROM messages where conversation.style='blog' ORDER BY metrics.views DESC limit 3