_lastUpdated & _createdAt
Filter by the modification date
Search by the last modification time of the resource
meta.lastUpdated(note: ts column in database) or by the creation time meta.createdAt(note: cts column in the database) FHIR format
Aidbox format
GET /fhir/Patient?_lastUpdated=2019-01-01
GET /Patient?_lastUpdated=2019-01-01
FHIR format
Aidbox format
GET /fhir/Patient?_createdAt=2019-01-01
GET /Patient?_createdAt=2019-01-01
Value can be a part of ISO date:
- only year -
2019 - year and month -
2019-03 - date -
2019-03-05 - hours -
2019-03-05T12 - mins -
2019-03-05T12:30 - secs -
2019-03-05T12:30:30 - micro-secs -
2019-03-05T12:30:30.333444 - with timezone -
2019-03-05T12:30:30Z or 2019-03-05T12:30:30+03
Do not forget url encode value of the expression in your code! Browser and Aidbox REST console will do some of encoding for you.
2019-03-05T12:30:30+03 =>2019-03-05T12%3A30%3A30%2B03If you use
= operator, Aidbox rounds the query date to the max and min value and searches in between this range:ts <= max_date_bound('2019-01-01') AND ts >= min_date_bound('2019-01-01')
You can use operators
lt,le,gt,ge as the prefix of value to make Aidbox generate inequality queries:_lastUpdated=lt2019-01 => ts < max_date_bound('2019-01')
_lastUpdated=ge2019-01 => ts >= min_date_bound('2019-01')
Aidbox uses the PostgreSQL precision for lastUpdated/ts and createdAt/cts - it's usually micro-seconds
Last modified 2yr ago