Queries

Prefix query

This will find all entities where field AlgVersion starts with TEST

select * from `samples` where AlgVersion >= 'TEST' and AlgVersion < 'TEST\\ufffd'

Timestamp query

SELECT * FROM `entity` WHERE `timestamp` <= datetime('2014-06-05T00:00:00Z')

Key query

select * from `entity` where __key__ = KEY(entity, 1199583969804288)