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
    7 years ago

    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