Aidbox
Search…
Aidbox documentation
Overview
Features
Licensing and Support
Aidbox UI
Versioning
Release Notes
Releases Archive
0.4.7 addendum
FAQ
Getting Started
Run Aidbox in Aidbox Sandbox
Run Aidbox locally with Docker
Run Aidbox as a SaaS
Aidbox configuration
Configure Aidbox and Multibox
Aidbox project
API constructor (beta)
Setup SMTP provider
Zen Configuration
API
FHIR API
REST API
Bulk API
Batch Upsert
Batch/Transaction
Cache
ETAG support
Reactive API
Sequence API
Encryption API
Compartments API
GraphQL API
RPC API
Profiling and validation
Profiling and validation overview
Profiling with zen-lang
Asynchronous resource validation
Profiling with AidboxProfile
Terminology
Aidbox terminology module overview
Import external (not-present) terminologies
Concept
CodeSystem
ValueSet
Handling hierarchies using ancestors
$translate on ConceptMap
Terminology Tutorials
FHIR Implementation Guides
🎓
HL7 FHIR Da Vinci PDex Plan Net IG
§170.315(g)(10) Standardized API for patient and population services
Tutorials
App development guides
Testing with Stresty
Working with Aidbox from .NET
Administration
Receive logs from your app
$matcho
$to-format
Storage
Overview
Database schema
Archiving
AWS S3
GCP Cloud Storage
Azure Blob Storage
Security & Access Control
Overview
Authentication Flows
Access Control
Multitenancy
Core Modules
Entities & Attributes
$json-schema
Monitoring
Logging & Audit
Modules
HL7 v2 Integration
FHIR Resources
Custom Resources
Aidbox Search
First-Class Extensions
Multibox
Multibox box manager API
Multibox monitoring
Plan API
Plan API Overview
Patient Access API
Integrations
Analytics
Audit
Authentication
Tools
Mappings
Aidbox SDK
Contact us
Reference
Configuration
Powered By GitBook
0.4.7 addendum
Additional instructions for update

createdAt (cts)

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 resources
update "patient" set cts = ts;
​
-- take cts for updated resources from history
update "patient" set cts = h.ts
FROM "patient_history" h
WHERE 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.
Previous
Releases Archive
Next - Overview
FAQ
Last modified 1yr ago
Copy link
Edit on GitHub