tmarshall
Advisor
Joined 14 years ago
User Profile
User Widgets
Contributions
Re: # in Conversation (LIQL Query) from Messages
Had more of a think and feel this is a process issue and not a code problem. Need to let the community moderators know that if they merge posts together and it is being used for our clever integration that they need to update the link to the now 'merged' post.Re: Message stats via APIv2
There is one flaw recently discovered when using topic.id by our middleware found. If/when a moderator moves a post the query breaks. It was suggested to go back to using 'id', so made another post https://community.khoros.com/t5/Developer-Discussion/in-Conversation-LIQL-Query-from-Messages/m-p/706448 related to this topic as still need a clever way to get the #of conversation , or need to have the moderator update the link to the merged topic. This would probably be the best approach with the least amount of effort 😉Re: # in Conversation (LIQL Query) from Messages
Hey luk - Yeah, I had the same issue when first starting out on this journey and satya was able to suggest that we use topic.id as a solution, however our moderator has moved posts and this 'broke' the query when using topic.id. So am now returning to figure out the best way to get the details from a post that mimics the '# in conversation' if I go back to using just id. When using topic.id our middleware person sum up all the child threads to get the number of people in the conversation, but now if use 'id' instead of 'topic.id' I can't get those details. Oh hum. I suppose we could do two queries? Need to dig around to figure out how to get '# in conversation' even if the message is moved by the moderator. Tricky, eh.# in Conversation (LIQL Query) from Messages
Hey Khoros Community Gurus, I'm trying to figure out how to get the '# in conversation' number using a LIQL query. I get the other stats, but am not sure about how to calculate the number that is shown on a post? Select id, replies.count(*), author.login, kudos.sum(weight), metrics.views, convesration.message_count FROM messages where id ='1864895'Role remove API call
https://community/vc/roles/name/Analytics/users/remove?role.user=id/1286 I've checked the user I'm logged in as as have permission to add/remove roles, but when I copy/paste this into the brower nav bar the action is not performed. Background We are apply a role to new users to restrict from adding a signature/DM without first acheiving a high role of activity (to cut down on spam). The mod team wants the ability to remove the role on a case by case basis. The role of the mod team does allow read/write of API calls. Ask I would like the mod team to be able on a case by case basis locate the Id of the impacted users and remove the role through the browser using this call. What other settings am I missing to now allow this call to complete in my testing? Is there an extensionon Chrome/Firefox I should be using to make POST calls? Appreciate the clarification.Re: Message stats via APIv2
Hey satya Good to hear from you and hope you are doing well 😉 It seems when I do the query for kudos it is it is limited to that specific thread, but I'm trying to get the aggregate of the kudos for the topic. I managed to figure out that if I add 'topic.id' you can see all the kudos which mirror the same value found in the thread after adding up each one from each message to the initial topic. https://community/api/2.0/search?q=SELECT sum(kudos.sum(weight)) FROM messages where topic.id = '1774748' LIMIT 1000 The same is true for the author, and wil list out each author in the topic. https://community/api/2.0/search?q=SELECT author.login FROM messages where topic.id = '1774748' LIMIT 1000 If I remove duplicates i can see the unique number of authors in the thread. Do you how to make the break out the code in the the following component? <component id="common.widget.discussion-stats"/> In short we need to pass in the message.id and display the 'discussion-stats' but as JSON that another application can pick up.Message stats via APIv2
When viewing a message in our the community there are stats on that message that give context to the moderators to focus on those topics. We would like to bring those stats in via APIv2 and include Replies, Date of topic, views, Kudos, 'in conversation I'm able to get a few of the data points but not all in my APIv2 query. https://community/api/2.0/search?q=SELECT id,replies.count(*),metrics.views,kudos.sum(weight),conversation.messages_count FROM messages where id = '1774748' Question The kudos.sum(weight) only brings back 3 rather than the total number of kudos. I'm not sure how to sum up the number of unique users in the topic? Appreciate the help on how to bring back the same stats in an APIv2 call. Thanks, Tim
