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 R...
Forum Discussion
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.
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 😉
