e.g.
When I try to get
from_date=2025-12-27, to_date=2025-12-27
, I get 3800 records.
When I try get
from_date=2025-12-27, to_date=2025-12-27 and limit = 3000
I get 3000 records, as intended. and max(time) is 1766878165511
Then when I try to get
from_date=2025-12-27, to_date=2025-12-27 and limit = 3000 and where=properties[“$time”] >= datetime(1766878165511)
I get only 1 record.
I’m doing this test to simulate for a specific date if there are records over 100 thousands - which is an api limit - I should get the other records only by querying with max time. But since the order is not guaranteed then “>= max(time)” may return again only 1 record.
kapa.ai
