Forum Discussion

jaread83's avatar
jaread83
Champion
8 years ago

Total Kudos Givers

Hi, We recently implemented a rank that grants the user 2 points per kudos. I have a component that is supposed to do a count of the amount of users and this worked fine until we granted the thanks...
  • TariqHussain's avatar
    TariqHussain
    8 years ago

    jaread83 - Found two errors in your query . 

     

    <#assign kudosCount = rest(apiVersion,"/search?q=" + "SELECT * FROM kudos where message.id = messageId limit kudosCountFirst"?url).data.items![] />

     

    messageId and kudosCountFirst are treated as string as you must need to wrap freemaker variable with ${}. Second you need to wrap messageId in quotes.  

     

    Updated Query : 

    <#assign kudosCount = rest(apiVersion,"/search?q=" + "SELECT * FROM kudos where message.id = '${messageId}' limit ${kudosCountFirst}"?url).data.items![] />

     

    PS : I don't drink beer :smileyvery-happy:

     

    Give kudos if you find my posts helpful or mark solution if it answers your query.

    Tariq

     

jaread83's avatar
jaread83
Champion

Hi TariqHussain, thanks for the advice. I have got it to half work but I need to convert the API v2 call to a number in order to apply some logic to it.

Is there a way to convert it to a number so I can get the count?

Basically, what I am trying to do is count the amount of kudos for a message, list the users who gave the kudos and cut it off at a specific number to add a 'and X amount of others'. Here is my code with your implementation:

 

<#assign messageId = env.context.message.uniqueId />
<#if messageId?? && messageId gt 0>
    <#assign apiVersion = "2.0"/>
    <#assign cutoff = 10 />
    <#assign counter = 0 />
    <#attempt>
        <#assign users = rest("/messages/id/${messageId}/kudos/givers?page_size=${cutoff}").users />
    <#recover>
        <#assign users = "" />
    </#attempt>
    <#attempt>
        <#assign kudosCountFirst = rest("/messages/id/${messageId}/kudos/count").value />
        <#assign kudosCount = rest(apiVersion,"/search?q=" + "SELECT * FROM kudos where message.id = messageId limit kudosCountFirst"?url).data.items![] />
    <#recover>
        <#assign kudosCountFirst = "" />
        <#assign kudosCount = "" />
    </#attempt>
    <#assign remaining = kudosCount?number - cutoff?number /> 
    <#if users??>
<#if kudosCount?number gte 1 ><span class="kudosgivers hidden">${kudosCount} <#if kudosCount?number == 1>user<#else>users</#if> liked/thanked this post:
<#list users.user as kudosGiver><#assign counter = counter+1 />${kudosGiver.login}<#if counter?number == cutoff?number && kudosCount?number gte cutoff?number+1>... and ${remaining} other <#if remaining == 1> user<#else>users</#if>. <#else><#if counter?number == kudosCount?number>. <#else>, </#if></#if></#list>
<#if kudosCount?number gte cutoff?number+1 >Click the number to view who else liked/thanked this post.</#if></span></#if>
    </#if>
</#if>

I hope you sre able to help. This is a bit of a head scratcher for me at the moment.

This is what the end result should look like:

With the Kudos weight added for some users, this throws it all off though.

TariqHussain's avatar
TariqHussain
Boss
8 years ago

jaread83 - Do you want to count the which that you are fetching from API V2? 

 

You can use ?size context object to count the size of array .  

 

<#assign remaining = kudosCount?size?number - cutoff?number />

You can also achieve this with below code.

 

<#assign kudosQuery = rest(apiVersion,"/search?q=" + "SELECT * FROM kudos where message.id = messageId limit kudosCountFirst"?url).data />
<#assign kudoCount = kudosQuery.size />
<#assign kudoResult = kudosQuery.items![] />

Give kudos if you find my posts helpful or mark solution if it answers your query

Tariq