Forum Discussion

skylinegtr's avatar
skylinegtr
Mentor
10 years ago

Help with API code

Hello! For some reason the following API only display posts from the tkb. It's supposed to show posting from tkb and forum. Has anyone run into this problem before?  Any help will be appreciated. Tha...
  • OlivierS's avatar
    OlivierS
    10 years ago

    skylinegtr I think it's probably best to run 2 querries then:

     

    <#assign messages_forum = rest("2.0","/search?q=" + "SELECT subject, view_href, post_time_friendly, board.id, teaser, author FROM messages WHERE board.id='forum' ORDER BY post_time DESC LIMIT 3"?url) />

    and

     

    <#assign messages_tkb = rest("2.0","/search?q=" + "SELECT subject, view_href, post_time_friendly, board.id, teaser, author FROM messages WHERE board.id ='tkb' ORDER BY post_time DESC LIMIT 2"?url) />
skylinegtr's avatar
skylinegtr
Mentor

OlivierS- When I changed the Limit 100 it display more content but it seems that the KB content display first and then the Forum content. I also got the following message. I only want 5 post to display, maybe 3 from KB and 2 the forum or mix content. 

 

The following has evaluated to null or missing:
==> message.@view_href  [in template "preview" at line 23, column 77]

Tip: If the failing expression is known to be legally null/missing, either specify a default value with myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing</#if>. (These only cover the last step of the expression; to cover the whole expression, use parenthessis: (myOptionVar.foo)!myDefault, (myOptionVar.foo)??

The failing instruction (FTL stack trace):
----------
==> ${message.@view_href}  [in template "preview" at line 23, column 75]
    #list messages.data.items as message  [in template "preview" at line 10, column 9]
----------

  

OlivierS's avatar
OlivierS
Lithium Alumni (Retired)
10 years ago

skylinegtr I think it's probably best to run 2 querries then:

 

<#assign messages_forum = rest("2.0","/search?q=" + "SELECT subject, view_href, post_time_friendly, board.id, teaser, author FROM messages WHERE board.id='forum' ORDER BY post_time DESC LIMIT 3"?url) />

and

 

<#assign messages_tkb = rest("2.0","/search?q=" + "SELECT subject, view_href, post_time_friendly, board.id, teaser, author FROM messages WHERE board.id ='tkb' ORDER BY post_time DESC LIMIT 2"?url) />