Forum Discussion

bnlucas's avatar
bnlucas
Adept
9 years ago

REST API - Find all forums and boards under category

 I'm trying to build an outline of our categories and the forums and boards associated with them. I have been searching the documentation for about an hour and I cannot figure out how to find forums ...
bnlucas's avatar
bnlucas
Adept
9 years ago
Within the UI, I have a category with four children. Three of which are designated as "forums" when you hover over the icon and the other is designated as a "board." When I run that LiQL that I posted, it is only returning the one designated as a board, not the three forums as well.

I believe I figured it out using ancestor_id over parent_id.
  • cike's avatar
    cike
    Champion
    9 years ago

    Hi bnlucas,

     

    within the Lithium universe forum and board are synonyms, but the common wording for this kind of node is board. Technically, the conversation.style of messages from a board is set to "forum".

     

    What's the difference between you forums and boards? Which node type did you choose when creating the elements?

     

    Best regards,

    Christian

    • bnlucas's avatar
      bnlucas
      Adept
      9 years ago

      cike - I wasn't the one who set up the boards, so I'm not exactly sure. I have fully figured it out though, something I couldn't find in the documentation anywhere. The LiQL didn't work, it only returns the "board"

       

      Using the following, I'm able to get the information:

       

      <ul>
<#list rest("/categories?restapi.response_style=view").categories.category as category>
    <li>${category.title}</li>
    <ul>
        <#list rest("/categories/id/${category.id}/boards?restapi.response_style=view").boards.board as board>
        <li>${board.title}</li>
    </#list>
    </ul>
</#list>
</ul>

      I found this looking at:

       

      SELECT boards FROM categories

      Which gives:

      SELECT * FROM boards WHERE ancestor_categories.id = '<ID>'

       

      • cike's avatar
        cike
        Champion
        9 years ago

        bnlucas - Using the LIQL query (replace '<ID>' with the category id) should return board object:

         

        SELECT * FROM boards WHERE ancestor_categories.id = '<ID>'

        These objects could be of any type Lithium provide (e.g. forum, idea, Q&A)

         

        Maybe, a screenshot of your community structure (Accessible via Community Administrator) could help to figure out what went wrong.

        Could you append such a screenshot?

         

        Best regards,

        Christian