Forum Discussion

Warren_Brill's avatar
Warren_Brill
Boss
6 years ago

List of all blog articles across the Community, but excepting one or more categories

I'd like to create a custom page that lists all blog articles across the site, but excepts one or more categories. Display parameters (e.g., ORDER BY) are less important than excepting the archives. ...
API
REST API v2 & LiQL
  • luk's avatar
    luk
    6 years ago

    Warren_Brill 

    when I put the JS into a component and save it, it executes from inside Studio, and I had to blow away the component entirely, lest it hang up Studio

    this you can easily avoid by wrapping your JS into an #if block, like so:

     

    <#if !page.name?matches('BizAppsPage')>
    <#-- add your JS, but not in the backend -->
    <@liaAddScript>

    </@liaAddScript>

    <#-- or simply -->
    <script>
        // here goes your JS
    </script>
</#if>

     

     

    Regarding the API call I can't really help right now, Lithium/Khoros just locked everybody out of the Dev-Docs Portal (they did a redesign there...), e.g. looks like this when trying to access the API v2 message collection...

     

    SuzieH DougS  please fix this =)!

  • Tarun's avatar
    Tarun
    6 years ago

    Warren_Brill 

    You can try to update your code with the following

    <#assign articleList = rest("2.0","/search?q=" + "Select * from messages where board.id='AroundtheStorageBlock'"?url) />
<#if (articleList.data.size?number > 0) >
<#list articleList.data.items as article>
<#-- your code for list comes here and you can acess detail about each article eg-->
<p><a href="${article.view_href}">${article.subject}</a></p>
</#list>
<#else>
<p>No articles in the given board ID</p>
</#if>

    The anchor would create the link to the article's details. 

    Hope that's the solution required.

    Regards

    Tarun Kumar 

cike's avatar
cike
Champion
6 years ago

Hi Warren_Brill,

what you need in this case is an API request looking like this:

SELECT * FROM messages WHERE board.id NOT IN ('xxxx', 'yyyy')

Of course with some additional filters for blog post type etc.

Unfortunately, APIv2 doesn't have a NOT_IN operator. 😞 I already created an idea for this in the past.

Up to the point where API gets such an operator, you can implement things using a white-list of boards/categories you want to query. Therefore create a Freemarker list with IDs you want to query:

<#assign boards = ["id_1", "id_2"] />

Then use this list as parameter in the query:

 

SELECT * FROM messages WHERE board.id IN ('${boards}')

 

Best regards,

Christian

 

  • Warren_Brill's avatar
    Warren_Brill
    Boss
    6 years ago

    Thanks Christian,
    I'm working with this as a base. Question:
    For

    <#assign boards = ["id_1", "id_2"] />

     are "id_1" and "id_2" actual node IDs (numeric, as found in LSI) or the alphanumeric IDs used in Community Structure?

    This would make ORDER BY feasible.

    • cike's avatar
      cike
      Champion
      6 years ago

      Warren_Brill  - use the node IDs from your community structure. These are the technical names for your nodes. 

      • Warren_Brill's avatar
        Warren_Brill
        Boss
        6 years ago

        So by "technical names", you mean the actual, alphanumeric IDs, not the fully numeric Node IDs as used in LSI. Every node has at least three identifiers: a title, an ID, and a numeric ID. I read your reply as referring to the middle one of the three as the technical name. Thanks.