Payal
Director
Joined 10 years ago
User Profile
User Widgets
Contributions
Re: API query equivalent to "trending discussions"
Lindsey - I think OOTB Trending Discussions have following criteria: Messages created in the past 7 or 30 days (which you have configured in admin panel) that have received the most kudos. So, you can use the following V2 Query to get trending messages of last 7 days: <#assign now = datesupport.now /> <#assign today = now.millisecondsAsString?number?number_to_datetime?iso("Europe/Zurich") /> <#assign lastWeek = now.addWeek(-1).millisecondsAsString?number?number_to_datetime?iso("Europe/Zurich") /> <#assign query = "SELECT * FROM messages WHERE post_time > " + lastWeek + " AND post_time < " + today + " and kudos.sum(weight) > 0 ORDER BY kudos.sum(weight) DESC" /> Please let me know if this helps. Thanks!117Views1like0CommentsRe: User Metrics / User Statistics
nad_dyra303 - I have made update to the following code: <div class="profile-likes"> <div class="profile-flex"><img src="/html/assets/icon-posts.png" /> <#assign getMetricsPost = rest("2.0", "search?q=" + "SELECT id,value FROM metrics WHERE id IN('net_overall_posts') and user.id='${page.context.user.id}'"?url).data.items/> <#list getMetricsPost as userMetricsPost> <span>${userMetricsPost.value}</span> </#list> Posts </div>264Views1like1CommentRe: How to add a button on a standard page?
Jhansi_k - Can you please confirm where you want to add a button? If you want to add a button in Community page or Forum, blog etc. , then in Khoros platform, we have quilts and components in studio. You can create a custom component and add html for button and place that component in the page quilt. For more information on how to create a custom component and add to the quilt, please see the below tkb link: https://community.khoros.com/t5/Components-endpoints-and-the/Create-a-custom-component/ta-p/108973 Thanks!175Views2likes2Comments