Online User Count is Completely Wrong
I'm trying to get an accurate count of online users and it's quite obvious the count is completely wrong just by looking at the results I'm encountering on my staging environment. The LIQL query used is fairly simple: SELECT count(*) FROM users WHERE online_status='online' Given the number of people who access our staging server, I would expect the result of this to be a low single digit number. Instead, I got a result of over 30 users. So I dug into the API results: SELECT login,last_visit_time FROM users WHERE online_status='online' The results list users with last visit times from 2020 and 2021 as well as users from earlier in 2022 that I know for a fact aren't online. How is Khoros defining an "online user" here? Is the behavior I'm seeing a bug or expected behavior?Possible? Display 30-day FRT on a Board Component?
Our Board Oversight teams would like a component on their boards that displays the First Response Time (FRT) average over the past 30 days. While I realize I can grab this in Community Analytics, and I also am comfortable around the API... I'm a bit of a newbie when it comes to grabbing time-constrained data via the API Here's the board component with the line in question: <#if userHasApplicableRole> <#assign frt = [30_DAY_BOARD_FRT_AVG] /> <#-- this --> <div class="dc-boardwidget-FRT" title="FRT 30-day average"> <i class="fa-regular fa-reply-clock"></i> <span>${frt}</span> </div> </#if> Is this possible with the API? wkd-oliver
Adobe AEM integration with Khoros ( For Comments )
Hi Team, This is regardingAdobe AEM integration with Khoros. We have a requirement like, We need to create the pages in AEM. But, Comments ( User generated content ) should be stored in Khoros. When I create a page in AEM , it should create one specific comments thread in Khoros as well. Users ( Customers ) Should be able to read/create /update/delete comment on the page ( which is in AEM) but , comments should be stored in Khoros. When ever I create a new page , it should create one unique comments thread in Khoros. Any suggestions please.Lab / Idea / Unconference Meetup?
I have a couple things on my community backlog that probably require some level of customization - I tend to be looking for stuff in Atlas that already has some traction or headway AND I see lots of "under consideration" ideas AND I see lots of "Did anybody make an XYZ widget in their community..." questions BUT what I haven't yet found (beyond this forum itself) is an available time and place for Devs to get together on their own and either attack a specific common problem OR talk together through a top of mind issue. It could be anything from a KhorosLed affair or even just an Unconferencewe put on ourselves. Would be REALLY great if there was a vanilla lab stood up to do actual live-action work that participants could then try to leverage in their own environments later. Am I just not finding this yet? Do we need to bootstrap something? BlakeH- has this come up before?How to get only Messages where some specific custom field have value?
Hi Team, I have a custom field added by Khoros in the messages object, I want toget only Messages where that specific custom field has value. Sample query: select c_abcd from messages where c_abcd!="" I don't want to get all messages and then in the loop filter the messages which don't have any value. Is there any direct API or solution to get the messages where thec_abcdcustom field has some value? Any related replies would be appreciated. Regards AmanAPI v2 Search doesn't work
Reading this page, I quote: "In v2, perform a one-or-more term search with a comma-separated list of terms wrapped in parentheses. Use this when you want to return messages that have at least one of these terms in the defined fields. WHERE subject MATCHES ('apples', 'bananas', 'cherries')" This query returns 2 results: select subject,body from messages where subject matches 'attachment' This query returns 0 results. select subject,body from messages where subject matches ('attachment','android') According to the documentation I should be getting results. Fair to say that it's not WAI?
TemplateModel properties/keys
Hello everyone I am trying to see thepage.context.thread.board properties because I did not find anything on the documentation. Basically what I am currently doing is logging this value into console but I gotlithium.eval.velocity.ThreadTemplateModel@7a6fcf85. I have tried with javascript Object.keys function but I am getting the string into an array and no relevant keys/properties. My main goal is to find a way to get whole thread kudos count without using v1 API call. Is there any other way to achieve that? I tried with v2 but is getting the topicMessage count only.Data/Metrics on Subscriptions
Hi there, I got a question that I thought would be straight-forward, but doesn't seem to be: "how many users are subscribed to category XYZ?" Apparently there's no good way to answer this? In looking through the documentation and forum, all I was able to find was this documentation here: https://developer.khoros.com/khoroscommunitydevdocs/docs/get-a-count-or-list-of-users-subscribed-to-a-board?_ga=2.165259263.1583072279.1692296336-111620096.1668529588 This is using a) the outdated v1 of the API and b) only returns counts for boards, blogs, or Groups. What about Group Hubs and Categories? Is there really no way to get a list of everyone who's subscribed to a particular Category? Thanks for any help!Handling the upcoming LIMIT and OFFSET changes
You might be aware of the upcoming changes to LIMIT and OFFSET having a maximum value of 1000 in 23.12. Obviously this is likely to cause a problem to any custom components that loop through data such as messages. Cursor will work fine in some scenarios, but any kind of custom pagination will need UI/UX work to access records greater than 2000! Using cursor we'd only be able to move forward and not skip to page 1000 for example. Any other thoughts on how this could be achieved with CURSOR?!
