Public
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Adept

Regarding me_toos,kudos search based on time

Hi Team , 

Do we have any way to search me_tooks and kudos based on time interval  column 

 I have tried  below query's but its not working 
SELECT *  FROM me_toos WHERE message.id = '2942882' AND time>2022-07-16T14:51:59.722 limit 100
SELECT * FROM kudos WHERE message.id = '2942882' AND time>2022-07-16T14:51:59.722 limit 100
 
But in response we could see the time column. if we use time interval its throwing error message like :  "message": "Invalid query syntax",
 
 
{
"type": "me_too",
"id": "forum_topic_metoo:979156",
"href": "/me_toos/forum_topic_metoo:979156",
"user": {
"type": "user",
"id": "",
"href": "/users/",
"view_href": ",
"login": ""
},
"message": {
"type": "message",
"id": "",
"href": "/messages/",
"view_href": ""
},
"time": "2022-07-16T14:51:59.722-07:00"
},
 
2 Replies 2
Adept

Hi @ccole ,

I Really not understand above replay.  Can you give me solutions here .in that link few of link not able to view it.

Hello @vagoud,

me_toos don't have a time constraint or sort:
https://developer.khoros.com/khoroscommunitydevdocs/docs/me_toos#constraints

kudos don't have a time constraint either, but it's possible to sort by time:
https://developer.khoros.com/khoroscommunitydevdocs/docs/kudos#time-1

Welcome to the Technology board!

Curious about our platform? Looking to connect on social technology? You've come to the right place!

Are you a Khoros customer? For direct assistance from our Support team, please visit the Support Forum.