Forum Discussion

SkyFlyinDancez's avatar
SkyFlyinDancez
Adept
8 years ago

Joint Statement in LiQL v2

Hi All,

Does anyone know does LiQL v2 support joint statement ?
Actually I am trying to retrieve message with top number of kudos. 

Other than making the 1st call to retrieve the message list and make 1 call for each message to retrieve kudos, is there any better solutions?

Current response for messages do have the kudos fields, but the value is another Select statement, is it mean that we need retrieve the kudos of each message 1 by 1 ?

Thanks & Regard,
Sky.

  • kavithams's avatar
    kavithams
    Guide
    8 years ago

    Hi,

     

    You can try this query for obtaining the kudos value for a particular message.

    SELECT kudos.sum(weight)  from messages where message.id="111"

     

    Regards,

    Kavitha M S

  • jferrandis's avatar
    jferrandis
    Expert
    8 years ago
    Hi

    Unfortunately, join are not supported in liql queries. So you have to make several request to do what you want