Forum Discussion

frardouin's avatar
frardouin
Guide
7 years ago

Get kudoed messages by user

Hi everyone,

I'm trying to display all the messages kudoed by a user in his profile page. This is currently not working in my component. I think the problem come maybe from the last query in the listing but I can't figure what's wrong. This is what I have:

 

<#assign currentUserid = page.context.user???then(page.context.user.id, user.id) />
<#assign kudoedMessages = restadmin("2.0", "/search?q=" + ("SELECT message.id FROM kudos WHERE user.id = '${currentUserid}'")?url).data.items![] />

<#list kudoedMessages as kudoedMessage>
    <#assign kudoedMessage = rest("2.0","/search?q=" + "SELECT * FROM messages WHERE id='${message.id}'"?url).data.items![] />
    <p>${kudoedMessage.id}</p>
</#list>

(Last quick question: Is it possible to "var_dump" variable in Freemarker? I have a hard time to get the property I need when in 2nd level query  )

  • VikasB's avatar
    VikasB
    7 years ago

    frardouin

    As 2nd APi also returning the array so we must put it in list also. Here is the corrected version. 

    <#assign currentUserid = page.context.user???then(page.context.user.id, user.id) />
<#assign kudoedMessages = restadmin("2.0", "/search?q=" + ("SELECT * FROM kudos WHERE user.id = '${currentUserid}'")?url).data.items![] />

<#list kudoedMessages as kudoedMessage>
    <#assign messages= rest("2.0","/search?q=" + "SELECT * FROM messages WHERE id='${kudoedMessage.message.id}'"?url).data.items![] />
    <#list messages as message>
	    <p>${message.id}</p>
	    <p>${message.subject}</p>
	    <p>${message.post_time?date}</p>
	    <p>${message.author.login}</p>
    </#list>
</#list>

3 Replies

Sort By
  • VikasB's avatar
    VikasB
    Boss
    7 years ago

    frardouin

    You need to send kudoedmessage.message.id instead message.id. Here is the corrected version.

    <#assign currentUserid = page.context.user???then(page.context.user.id, user.id) />
<#assign kudoedMessages = restadmin("2.0", "/search?q=" + ("SELECT * FROM kudos WHERE user.id = '${currentUserid}'")?url).data.items![] />

<#list kudoedMessages as kudoedMessage>
    <#assign kudoedMessage = rest("2.0","/search?q=" + "SELECT * FROM messages WHERE id='${kudoedMessage.message.id}'"?url).data.items![] />
    <p>${kudoedMessage.id}</p>
</#list>

     

  • frardouin's avatar
    frardouin
    Guide
    7 years ago

    Thanks it's helping VikasB. 

     

    Now I'm able to render the message id with:

    <p>${kudoedMessage.message.id}</p>

    But I don't understand why I'm unable to render the rest of the message fields. Logically, when I check the message data structure, I should be able to get those field like that :

    <p>${kudoedMessage.message.subject}</p>
<p>${kudoedMessage.message.post_time}</p>
<p>${kudoedMessage.message.author.login}</p>
  • VikasB's avatar
    VikasB
    Boss
    7 years ago

    frardouin

    As 2nd APi also returning the array so we must put it in list also. Here is the corrected version. 

    <#assign currentUserid = page.context.user???then(page.context.user.id, user.id) />
<#assign kudoedMessages = restadmin("2.0", "/search?q=" + ("SELECT * FROM kudos WHERE user.id = '${currentUserid}'")?url).data.items![] />

<#list kudoedMessages as kudoedMessage>
    <#assign messages= rest("2.0","/search?q=" + "SELECT * FROM messages WHERE id='${kudoedMessage.message.id}'"?url).data.items![] />
    <#list messages as message>
	    <p>${message.id}</p>
	    <p>${message.subject}</p>
	    <p>${message.post_time?date}</p>
	    <p>${message.author.login}</p>
    </#list>
</#list>