Create RECENT, most POPULAR Discussion Component Based on landing page category board

Question

Hi everyone! I'm still a bit new to creating components on Lithium and would really appreciate some pointers.

I'm trying to create a "Most popular Topics" component that depend on these factors:

How recent each topic was (was it posted within this wee?)
Total number of discussions taking place during specified time frame (the number of comments received during the one week period)
Incoming the board that the current post is in (eg, if I googled, how to create landing pages, and it took me to an article in Lithium, I'd like to know what parent board is. So I an create this component... Since dont' we have to call articles based on which board they are in?)

The board "ID" would need to be dynamic then right? Since I would not know which article board the landing page article is hosted on.

Would anyone happen to know how to create something like this? and if so, perhaps leave a few line of code as practical examples. Thank you!

tariqhussain · Answer

maxwelldhsu&nbsp;-&nbsp;&nbsp;Most Recent Articles -&nbsp;&nbsp;Select * from messages where depth = 0 order by post_time DESCMost Pupular&nbsp;Articlrs -&nbsp;&nbsp;&nbsp;Select * from messages where depth = 0 order by kudos.sum(weight) DESC&nbsp;&nbsp;Regarding the factors:&nbsp;You can get this from the post_time field, which will be returned by the above queries.&nbsp;Do you want to get the articles&nbsp;posted under one week? or the comment posted on the articles under one week? This thread would be helpful to get the articles which are posted under one week&nbsp;https://community.lithium.com/t5/Developer-Discussion/posts-count-of-last-7-days/m-p/315841/highlight/true#M12205Parent board is a board under which the article is created E.g for this post the parent board will be Developer Discussion. &nbsp;You can fetch this from the result you will get from the message API's&nbsp;board.id&nbsp;or&nbsp;board.title. In case you want to fetch all the articles from one board you can use this query -&nbsp;SELECT * FROM messages WHERE board.id = 'wireless_support' &nbsp;Documentation for this&nbsp;https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&amp;collection=messages#constraints-board.id

maxwelldhsu · Answer

TariqHussain&nbsp;Thanks for this! I'll read more on it.&nbsp;Quick question on the side. If I'd like to test a REST api call on Stage, however I'm calling my actual community site. How do I get it to work?&nbsp;On stage, it shows an error. I assume because the Board ID doesn't exist in stage, but on the live community.&nbsp;&nbsp;Thanks again!

tariqhussain · Answer

maxwelldhsu&nbsp;- If you are trying on this query on stage, use a board id which is available on stage. &nbsp;You also can try this query on production as below.&nbsp;https://production-community-url/api/2.0/search?q=SELECT id, kudos, subject FROM messages WHERE board.id = 'Production-board-id' AND depth = 0 ORDER BY kudos.sum(weight) DESC

Forum Discussion

Create RECENT, most POPULAR Discussion Component Based on landing page category board

Related Content

Messages and Categories

Select * from Categories (returns 0 categories 🤔)

Custom components to show categories/title

Delete an SDK @override Component?

Aurora Storybook - Component Library

Recent Discussions

Connecting Khoros data to CRM (Salesforce)

API v1 docs gone since Atlas migration to Aurora

Does anyone know how to change the display title of Custom Fields in Aurora?

Can someone walk me through authenticating and using Postman with Aurora?

Seeking Advice on Restricting Access to a posts to those who have the permalink.