HariniVuppala
Expert
Joined 8 years ago
User Profile
User Widgets
Contributions
Re: Non Spam Posts for a given time frame
CarlaAYou can fetch the messages that are not marked as SPAM by including the following condition in your query: moderation_status: "approved". For ex: select count(*) from messages where moderation_status="approved" and post_time>=2025-01-01T00:00:00.000-00:00 and post_time <= 2025-02-26T23:59:59.999-00:0023Views0likes0CommentsRe: show last edited date on TKB articles
etisson You can use the 'TKB Article Details and Options' component, provided by Khoros, in the TKB article page header quilt. This component allows you to view information such as the article's creation and modification dates along with user details.207Views0likes0CommentsRe: How to get a list of deleted messages?
leeclemmerYes, you are right there is no way to pull only specific events. Once you have the bulk data in CSV or JSON format, you need to implement logic to extract only the desired events. Additionally, another approach to retrieve deleted messages is to subscribe to the 'MessageDelete' event. By using the delete message API response, you can identify which messages have been deleted. For more information, please refer to https://developer.khoros.com/khoroscommunitydevdocs/docs/subscribe-to-community-events161Views1like0CommentsRe: How to get a list of deleted messages?
leeclemmerIf you need to periodically retrieve a list of deleted messages, you can refer to the 'bulkdata' for the action key 'message.delete' using the following API call. curl "https://api.lithium.com/lsi-data/v2/data/export/community/<community_id>?fromDate=YYYYMMDDhhmm&toDate=YYYYMMDDhhmm" -H "client-id: <client-id>" -u "<token>:" For additional information, please refer the following document. https://developer.khoros.com/khoroscommunitydevdocs/reference/bulk-data-api-v2#actionkey-events219Views3likes1CommentRe: Can I find the count of unanswered topics (for a given forum) for a certain date?
keithkelly The below query might be helpful to you to get the unanswered topics count. select count(*) from messages where conversation.solved=false and board.id="boardid" and depth=0 and post_time > 2024-02-01T00:00:00.000-00:00 and post_time < 2024-02-01T23:59:59.999-00:00305Views1like1Comment