We use cookies for analytics and marketing to improve your experience and communicate with you. You can accept or reject cookies below. View our Cookie Policy for more information.

Aidbox Docs Logo
Aidbox Docs
FHIR serverRelease notesTalk to usAsk communityBlogHealth Samurai
Run Aidbox locallyRun Aidbox in SandboxExamples
Product
FHIR serverRelease notesTalk to usAsk communityBlogHealth SamuraiRun Aidbox locallyRun Aidbox in SandboxExamples
CtrlK
Login
Run Aidbox in SandboxRun Aidbox locallyUse Aidbox with JavaUse Aidbox with TypeScriptUse Aidbox with PythonUse Aidbox with C#Run Aidbox on AWSUpload Sample Data
FeaturesArchitecture
Delete dataSet up uniqueness in Resource
Custom SearchParameter tutorialCreate custom Aidbox Search resourceMultilingual search tutorialMigrate from Aidbox SearchParameter to FHIR SearchParameterChange sort order by locale collation
Synthea by Bulk API$dump-sql tutorial
Allow patients to see their own dataRestrict operations on resource typeRelationship-based access controlCreating user and set up full user accessRestricting Access to Patient DataCreate and test access control
Flexible RBAC built-in to AidboxRBAC with JWT containing roleRBAC with ACL
Set-up token introspectionProhibit user to loginManaging Admin Access to the Aidbox UI Using Okta GroupsRun Multibox locallyHow to enable labels-based access controlHow to enable patient data access APIHow to enable SMART on FHIR on Patient Access APIHow to enable hierarchical access controlHow to configure FHIR Audit LogHow is an HTTP request processed in AidboxHow to configure SSO with another Aidbox instance to access Aidbox UIHow to configure SSO with Okta to access Aidbox UIHow to configure sign-in with Apple for access to the Aidbox UIHow to configure Azure AD SSO for access to the Aidbox UIHow to configure Microsoft AD FS for access to the Aidbox UIHow to configure Azure AD SSO with certificate authentication for access to the Aidbox UIHow to configure GitHub SSO for access to Aidbox UIHow to configure Keycloak for access for AidboxUIAuto-create User from foreign token tutorialHow to implement consent-based access control using FHIR Search and Aidbox Access PolicyDebug Access ControlAccessPolicy best practicesHow to configure Basic Auth flowDeprecated Access policy dev toolHow to configure Authorization Code GrantHow to configure Client Credentials GrantHow to configure Implicit GrantHow to configure Token ExchangeHow to configure Resource Owner Grant flowConfiguring Two Factor Authentication in Aidbox Identity ProviderSSO with External OAuth Identity ProviderAccess policies examples
Load ICD-10 terminology into AidboxUploading IG terminology content to external FHIR terminology serverLocal Terminology
ISiKCarin BBUS CoreDavinci PdexmCode
Postmark integration tutorialMailgun integration tutorial
Kafka AidboxTopicDestinationClickHouse AidboxTopicDestinationTutorial: Produce QuestionnaireResponse to Kafka topicGCP Pub/Sub AidboxTopicDestinationWebhook AidboxTopicDestinationAidboxTopicSubscription NATS tutorialAidboxTopicSubscription RabbitMQ tutorialAidboxTopicSubscription ActiveMQ tutorial
How to create FHIR npm package
Extensions using StructureDefinitionExtensions using FHIRSchema
Custom resources using FHIR SchemaCustom resources using StructureDefinition
Migrate custom resources defined with Entity and Attributes to FHIR SchemaMigrate custom resources defined with Zen to FHIR Schema
How to load FHIR IG with Init BundleEnvironment Variable
IG Package from Aidbox RegistryPublic URL to IG PackageLocal IG Package
Aidbox FHIR APIUploadFIG Tool
Run Aidbox with FHIR R6Migrate from Multibox to AidboxSDC with Custom ResourcesMigrate from legacy licence portal to Aidbox portalSet up Aidbox with PostmanHow to run Aidbox in GCP Cloud RunHow to run Aidbox using different JavaAI Prompts
Overview
Licensing and Support
ProjectsLicensesMembers
Aidbox NotebooksREST ConsoleDatabase ConsoleAttrs StatsDB TablesDB Queries
VersioningRelease NotesFAQContact us
Configuration
Recommended environment variablesSettingsConfigure Aidbox and MultiboxInit Bundle
API
API Overview
CreateReadUpdatePatchDelete
SearchParameterInclude and RevincludeChaining
Aidbox SearchBundleHistory$everything on Patient
Aidbox and FHIR formatsCapability Statement$documentObservation/$lastn$validateSQL endpoints$matcho$to-formatAidbox versionHealth check$meta$meta-add$meta-delete
Configure Access Policies for Bulk API$dump$dump-sql$dump-csv$export$load and /fhir/$load$import and /fhir/$importAidbox.bulk data importBulk import from an S3 bucket
Batch/TransactionGraphQL API
PractitionerPractitionerRoleOrganizationOrganizationAffiliation
Plan API Overview
Create-archiveRestore-archivePrune-archived-dataDelete-archive
ETAG supportCacheChanges APIRPC APISequence APIEncryption APIBatch Upsert
Access Control
Overview
User managementApplication/Client Management
Basic HTTP AuthenticationOAuth 2.0Token IntrospectorSSO with External Identity Provider
Access Policies
SMART App LaunchSMART backend services
SMART: Asymmetric ("private key JWT") authenticationSMART: Symmetric (/"client secret") authentication
SMART: Scopes for Limiting AccessPass Inferno tests with AidboxExample: SMART app launch using Aidbox and KeycloakExample: SMART app launch using Smartbox and Keycloak
Organization-based hierarchical access controlCompartments APIPatient data access API
Label-based Access Control
Audit and Logging
Artifact Registry
Artifact Registry overviewStructureDefinitionSearchParameter CodeSystemValueSetConceptMap
Terminology Module
Terminology Overview
Coded ValuesProfiles, Binding, and Validation
SetupHybrid ModeCapabilities
Database
Database overviewPostgreSQL RequirementsDatabase schemaPostgreSQL Extensions
HA AidboxDB
Migrate to AidboxDB 16Working with pgAgent
Modules
Setup Aidbox with FHIR Schema validation engine
Skip validation of references in resource using request headerAsynchronous resource validation
Run Aidbox with OpenTelemetry locallyHow to export telemetry to the OTEL collector
OpenTelemetry logsElastic Logs and Monitoring IntegrationDatadog log management integrationLoki log management integration
Log analysis and visualization tutorialExport logs to Datadog tutorialSet up logs with Aidbox project
Extending Aidbox Logs
Log appendersLog transformationsLog SchemaOTEL logs exporter parameters
How to export metrics to the OTEL collectorUse Aidbox Metrics ServerSet-up Grafana integration
OpenTelemetry MetricsOTEL metrics exporter parameters
How to use tracingOTEL traces exporter parameters
Aidbox Topic-Based SubscriptionsAidbox SubSubscriptions
Getting startedAidbox Forms Interface
UI Builder InterfaceAI Assistant
Form SettingsWidgetsComponentsEntry ModeVersioningValidationNestingForm customisation in theme editorForm signatureNHS integration
How to: Populate forms with dataHow to extract data from formsHow to calculate form filling percentageHow to create a form with dynamical answers into questions
Multilingual formsFHIRPath Expressions with Visual EditorData ExtractionPopulation
Import QuestionnaireForm sharing
Native look form printingTemplate-based PDF generation
FHIR versionsOffline forms
Request Interception
ConfigurationForms multitenancyBuilding reports using SQL on FHIRIntegration with external terminology serversExternal Form Renderer in Builder PreviewExternal FHIR servers as a data backendStore attachments in S3-like storages
Form creationHow to create a dynamic formHow to create a form with calculated fieldsForm CustomisationVersioningForm sharingAidbox Form WorkflowChanging data after form signingFHIR Questionnaire to Aidbox forms and back conversion
Any familiar form editor (docs deprecated)Access control in formsAdaptive FormsAudit logging in formsAidbox Form Gallery
$run operation$materialize operationDefining flat views with view definitionsMigrate to the spec-compliant ViewDefinition formatQuery data from flat viewsReference
Admission Diagnosis Section (/V3)Advance directives section (/entries optional) (/V3)Advance directives section (/entries required) (/V3)Allergies and intolerances section (/entries optional) (/V3)Allergies and intolerances section (/entries required) (/V3)Assessment SectionChief Complaint SectionChief Complaint and Reason for Visit SectionComplications Section (/V3)Course of Care SectionDICOM Object Catalog Section - DCM 121181Default Section RulesDischarge Diagnosis Section (/V3)Document HeaderEncounters section (/entries optional) (/V3)Encounters section (/entries required) (/V3)Family History Section (/V3)Functional Status Section (/V2)General Status SectionGoals SectionHealth Concerns Section (/V2)History of Present Illness SectionHospital Consultations SectionHospital Course SectionHospital Discharge Instructions SectionHospital Discharge Physical SectionHospital Discharge Studies Summary SectionImmunizations section (/entries optional) (/V3)Immunizations section (/entries required) (/V3)Medical (/General) History SectionMedical Equipment Section (/V2)Medications Administered Section (/V2)Medications section (/entries optional) (/V2)Medications section (/entries required) (/V2)Mental Status Section (/V2)NotesNutrition SectionObjective SectionOperative Note Fluids SectionOperative Note Surgical Procedure SectionPast Medical History (/V3)Payers Section (/V3)Plan of Treatment Section (/V2)Postprocedure Diagnosis Section (/V3)Preoperative Diagnosis Section (/V3)Problem section (/entries optional) (/V3)Problem section (/entries required) (/V3)Procedure Description SectionProcedure Disposition SectionProcedure Estimated Blood Loss SectionProcedure Implants SectionProcedure Specimens Taken SectionProcedures section (/entries optional) (/V2)Procedures section (/entries required) (/V2)Reason for Visit SectionResults section (/entries optional) (/V3)Results section (/entries required) (/V3)Review of Systems SectionSocial History Section (/V3)Vital signs section (/entries optional) (/V3)Vital signs section (/entries required) (/V3)
How to deploy the serviceProducing C-CDA documentsHow to customize conversion rules
HL7 v2 integration with Aidbox projectMappings with lisp/mapping
X12 message converter
Power BI
Mappings
Setup SMTP provider
Getting StartedAuthentication with mTLSPharmacies Synchronization
NewRx MessageCancelRx Message
RxRenewal MessageRxChange Message
DetectedIssueHow to test Callback
DirectoryDownload MessageGetProviderLocation MessageAddProviderLocation MessageUpdateProviderLocation MessageDisableProviderLocation Message
FDB
Environment VariablesList of Metrics
Frequently Asked Questions
Run MDM locallyConfigure MPI module
Find duplicates: $matchMerging and Unmerging Records: $merge and $unmergeMatching Model ExplanationMathematical Details
Set up Smartbox locallyDeploy Smartbox with Kubernetes
(/G)(/10) Standardized API for patient and population services
Source attributesFeedback Sections
Perform EHR LaunchRevoke Granted AccessSet up EHR-level CustomizationCheck email templatesSetup email providerRegister UsersSet up SSO with Auth0Publish Terms of Use Link Onto the Documentation PageFind Out What Resources Were Exported During the $export OperationFind Documentation Endpoint
Considerations for Testing with Inferno ONCAdding Clients for Inferno TestsMultitenancy ApproachWhat Is TenantEmail Templating
MCPAidboxTrigger
Getting StartedFHIR ResourcesDefault MappingsModule LimitationsMessage Lifecycle
File storage
AWS S3GCP Cloud StorageAzure Blob StorageOracle Cloud Storage
Deployment and maintenance
Deploy Production-ready Aidbox to KubernetesDeploy Aidbox with Helm ChartsHighly Available AidboxSelf-signed SSL Certificates
Run Aidbox on managed PostgreSQLHow to inject env variables into Init Bundle
Crunchy Operator (/pgbackrest)pg\_dumppg\_basebackupWAL-G
Get Suggested IndexesCreate Indexes Manually
Developer experience
Developer experience overviewWorking with AIAppsUse Aidbox with React
Aidbox JavaScript SDKNodeJs SDKPython SDK
Examples
Solutions
Overview
Run Aidbox + FHIR Portal locallyRun Aidbox + FHIR Portals on k8sMigrate from Smartbox to Aidbox + FHIR App portal
App GalleryDeveloper Sandbox Portal Flow DescriptionFHIR Admin portal
Pass Inferno Tests with AidboxPass Inferno Visual Inspection and Attestation
Reference
Aidbox Settings Reference
IAM Module ResourcesSDC Module ResourcesBase Module ResourcesBulk Module ResourcesAWF Module ResourcesCloud Module ResourcesHL7v2 Module ResourcesSQL on FHIR Module Resources
FHIR Schema Reference
Notification Resource ReferenceMailgun Environment VariablesPostmark Environment Variables
FHIR SDC APIAidbox SDC APIGenerating Questionnaire from PDF APIGenerating Questionnaire from openEHR Template API
Aidbox SQL FunctionsMatcho DSL ReferenceFAR Package Management API
Deprecated
aidbox.mdm/update-mdm-tablesaidbox.mdm/match
FTR
Run Aidbox Locally Using Aidbox Configuraiton ProjectAidbox Configuration Project StructureSet up and Use Configuration ProjectsEnable IGsRepositorySeed ImportManage Indexes in Zen ProjectSeed v2Migrate to Git Aidbox Configuration Projects
Zen ConfigurationAidbox Project RPC Referenceaidbox.config/config
Custom Resources Using Aidbox ProjectFirst-Class Extensions Using ZenZen Indexes
US Core IG Support Reference
Aidbox Built-in TasksTask Executor APITask User API
Workflow User API
ServicesMonitoring
Touchstone FHIR 4.0.1 Basic ServerTouchstone FHIR USCore ClinData
Start Aidbox Locally with US Core IG EnabledAdd US Core IG to a Running Aidbox Instance
HL7 FHIR Da Vinci PDex Plan Net IG
Inferno Test-Suite US Core 3.1.1
API Constructor (/Beta)
Write a Custom Zen ProfileLoad Zen Profiles into Aidbox
Set up SubscriptionTopicTutorial: Subscribe to Topic (/R4B)
SubscriptionTopic APISubscription API
FTR Specification
FTR from CSVFTR from FHIR IGFTR from FTR — Direct DependencyFTR from FTR — Supplement
FTR ManifestLoad SNOMED CT into AidboxLoad LOINC into AidboxLoad ICD-10-CM into AidboxLoad RxNorm into AidboxLoad US VSAC Package to AidboxImport via FTR
Zen Search ParametersAccess Control Lists (/ACL)
Entities and AttributesFirst-Class Extensions Using AttributeCustom Resources Using EntityWorking with ExtensionsAidbox Search Parameters
Layout DSL (docs deprecased)Document DSL (docs deprecased)Launch DSL (docs deprecased)Lisp (Deprecated)FinalizeConstraints DSL (Deprecated)Finalize DSL (docs deprecased)Form DSL (docs deprecased)Lisp API (docs deprecased)Form API (docs deprecased)Workflow API (docs deprecased)Addendum API (docs deprecased)
AidboxDB Environment VariablesCustom SearchSearchQuerySubscribe to New Patient Resource
X-Audit Header
Patient Encounter Notification Application
Resource Generation with Map-to-FHIR-Bundle-Task and Subscription TriggersAPM AidboxAutomatically Archive AuditEvent Resources in GCP Storage GuideHL7 v2 Pipeline with Patient MappingHow to Migrate to Apline LinuxHow to Migrate Transaction Id to BigintHow to Fix Broken DatesConfigure Multi-Tenancy
AidboxProfileGCP Pub/Sub
SMART on FHIRSet up SMART on FHIR in AidboxGet a SMART App Launched
SMART on FHIR
$translate-concepts (deprecated)Handling hierarchies using ancestors (deprecated)
ValueSet Expansion (deprecated)ValueSet Code Validation (deprecated)Create a ValueSet (deprecated page)
CodeSystem Concept Lookup (deprecated)CodeSystem subsumption testing (deprecated)CodeSystem Code Composition (deprecated)
Import flat file (/CSV) (deprecated)$import operation (deprecated)Ready-to-use terminologies (deprecated)
$translate on ConceptMap (deprecated)
  1. Overview
    2. /
  2. Aidbox UI
View as Markdown
View this page as plain text
Edit on GitHub
Edit this page on GitHub

DB Queries

Please start a discussion or contact us if you have questions, feedback, or suggestions.

DB Queries provides info on running queries and helps to detect slow queries and terminate them if you need.

DB Queries

PreviousDB Tables
NextVersioning

    © Health Samurai
    •
    Contact us•Docs source (40c0e5f)•