Forum Discussion

Myko_P's avatar
Myko_P
Expert
7 years ago

A custom component that shows 3 last posts selected from all the community blogs

Hi, I am trying to build custom component/widget for the main page. The idea is to show our users in a visual manner 3 last posts selected from all the community blogs. Selected blog posts should...
Payal's avatar
Payal
Director
7 years ago

Myko_P -  Yes, you can fetch the messages from all the community blogs by using the below query:

<#assign messageId = rest("2.0","/search?q=" + "SELECT id FROM messages WHERE conversation.style='blog'  AND depth = 0 ORDER BY post_time DESC LIMIT 3"?url).data.items />

 

Thanks

Myko_P's avatar
Myko_P
Expert
7 years ago

Thank you, Payal !

Could you please take a look at my code above? Is it OK or I missed something?

  • Payal's avatar
    Payal
    Director
    7 years ago

    Myko_P - You can fetch all the required data by using  v2 Query only and there is no need to use rest v1 API call:

    <#assign messageId = rest("2.0","/search?q=" + "SELECT * FROM messages WHERE conversation.style='blog'  AND depth = 0 ORDER BY post_time DESC LIMIT 3"?url).data.items />

    replace 'id' by '*' and then use <#list> to display all the required messages.

    Thanks,

    Payal