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.