Forum Discussion

muraleedharan's avatar
3 years ago

how to retrieve count and user info of kudos given and received using single API/LiQl

Please any one help me to get the information about each user and count (like screenshot) of given and received kudos through single API/LiQl

 

 

  • muraleedharan,

    You need to run below API to achieve this in your results

    SELECT login,kudos_received.sum(weight) FROM users ORDER BY kudos_received.sum(weight) DESC
    SELECT login,kudos_given.sum(weight) FROM users ORDER BY kudos_given.sum(weight) DESC