New column added to all resource tables - cts (createdAt) - a time of resource creation. All CRUD operations respect this column, but we do not include automatic migration for this column because of performance reasons. To set this column in the right value for existing data, you have to run the following statements manually on your box:
-- set cts to ts - right value for created resourcesupdate "patient" set cts = ts;-- take cts for updated resources from historyupdate "patient" set cts = h.tsFROM "patient_history" hWHERE h.id = "patient".id and h.status = 'created';
Replace "patient" and "patient_history" with the lowercased name of resource types you want to update.
In API this column will be present as Resource.meta.createdAt in Aidbox Format and as Resource.meta.extension(url: 'ax:createdAt').valueInstant in FHIR.