Forum Discussion

omygoodness's avatar
omygoodness
Mentor
8 years ago

My kudoed posts REST

I am looking for api call that will replace query: SELECT * FROM kudos WHERE user.id = '3' What I need is same rest call that is used at default lithium page: kudos/userpage/user-id/3/tab/messages...
  • jferrandis's avatar
    jferrandis
    8 years ago

    Hi omygoodness,

     

    The query you need is 

    SELECT * FROM messages WHERE author.id = '3' AND kudos.sum(weight) >0

    It will give you all messages authored by user which have recieved kudos

  • omygoodness's avatar
    omygoodness
    8 years ago

    When I was waiting for help on community I came up with query:

    SELECT * FROM messages WHERE kudos.sum(weight) > 0 AND author.id='${viewed_user_id}' ORDER BY kudos.sum(weight) DESC

    Anyway. jferrandis Thank you for answer.

jferrandis's avatar
jferrandis
Expert
8 years ago

Hi omygoodness,

 

The query you need is 

SELECT * FROM messages WHERE author.id = '3' AND kudos.sum(weight) >0

It will give you all messages authored by user which have recieved kudos

  • omygoodness's avatar
    omygoodness
    Mentor
    8 years ago

    When I was waiting for help on community I came up with query:

    SELECT * FROM messages WHERE kudos.sum(weight) > 0 AND author.id='${viewed_user_id}' ORDER BY kudos.sum(weight) DESC

    Anyway. jferrandis Thank you for answer.

    • jferrandis's avatar
      jferrandis
      Expert
      8 years ago

      I edited my former message with the correct query.

       

      An addition, to handle a "message i kudoed" custom component, you will have to make 2 queries

       

      Get the message the user has kudoed

      SELECT * FROM kudos WHERE user.id='3'

      Then, you will have to parse it to get message details

      <#if myQueryResult.data.status == "success" && myQueryResult.data.size gt 0 >
      <#list myQueryResult.data.items as message>
      <#assign messageDetailQuery = rest("2.0","/search?q=" + "SELECT * FROM messages WHERE id=${message.message.id}'"?url) /> 
      <#if messageDetailQuery.data.status == "success" && messageDetailQuery.data.size gt 0 >
      ... make you own ui ...
      </#if>
      </#list>