Nick3
8 years agoHelper
Get all messages that are less than a certain edit time
Hello,
I'm trying to fetch all messages from a certain edit time but it seems to not working.
SELECT * FROM messages WHERE current_revision.last_edit_time < '2017-05-18T10:00:00-07:00'
It returns an "invalid query syntax". Is it possible? API v1 call is acceptable.
Thanks
Hi Nick3,
at the moment you can't use the current_revision.last_edit_time as a constraint in your LIQL queries. This is not supported by Lithium's APIv2.
Best regards,
Christian