Hi guys I am using the following query to get user's role, but it returns nothing, I am sure this user has roles, I have tried different user id. https://api.lithium.com/community/2.0/yutwg22796/search?q=SELECT * FROM roles where users.id%3D'30' //30 is the user id.  the response is: { "status": "success", "message": "", "http_code": 200, "data": { "type": "roles", "list_item_type": "role", "size": 0, "items": [] }, "metadata": {} }   Regards Shong ... View more

Hi I am calling API v2 to retrieve the messages from Lithium, what I want is to retrieve only the messages whose last_edit_time is greater than a value. I see only the post_time can be used in the where condition. Any idea to get only the new messages which is updated/edited recently? Thanks! Shong ... View more