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

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>