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"
},
