skylinegtr you can filter by id:
SELECT id, title, boards FROM categories WHERE id IN('forums','kb')
skylinegtr in future post, please list what you've been trying ;)
Now, based on this tutorial, and the category resource, I assume this code would work:
<h2>JOIN THE DISCUSSION</h2>
<#--Use the rest FreeMarker context object, passing the rest_version parameter and LiQL query (encoded by appending ?url) -->
<#assign categories = rest("2.0","/search?q=" + "SELECT id, title, topics.count(*), messages.count(*), views, view_href FROM categories ORDER BY topics.count(*) ASC"?url) />
<ul>
<#list categories.data.items as category >
<li><a href=“${category.view_href}”>${category.title}</a><br />
Topics count: ${category.topics.count} <br />
Messages count: ${category.messages.count} <br />
</li>
</#list>
</ul>
Disclaimer: I won't be responsible for any side effects of my code. Please test, test, and test on your stage environment first before pushing to production ...
OlivierS – Thanks for your help with this. Sorry, I should have been clearer.
What I’m trying to do is to display 3 subject/topics for each category in the custom components.
For example:
The Blog has Topic/Subject- Bartz Blog, Ben’s Suport, Support News, Process
Knowledge & Support has Topic/Subject-Customer Knowledge Base, Customer Product Ideas, Partner Knowledge Base.
It’s my first time dealing with API’s.
The code below lists categories and the boards within them.
<#assign category = rest("2.0","/search?q=" + "SELECT id, title, boards FROM categories"?url).data.items![] />
<#list category as category>
<h2>${category.title}</a></h2>
<#assign board = rest("2.0","/search?q=" + category.boards.query?url).data.items![] />
<ul>
<#if board?size gt 0>
<#list board as board>
<li><a href="${board.view_href}">${board.title}</a></li>
</#list>
<#else>
<li>No boards in this category</li>
</#if>
</#list>
It shows the following:
Knowledge & Support
-Customer Knowledge Base
If I only want the categories for the Forums or Knowledge and Support? How can I accomplish this?
skylinegtr you can filter by id:
SELECT id, title, boards FROM categories WHERE id IN('forums','kb')
OlivierS Thank you!
