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 lis...
  • 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>
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>