Forum Discussion

Nick3's avatar
Nick3
Helper
8 years ago

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

1 Reply

  • 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