Configure Search API
Aidbox Search API can be configured in many ways. This page explains the difference between general types of Search API.
The engine is responsible for SQL generation for search operations. SQL by jsonpath and jsonknife is different for search parameter types: date, number, quantity, reference, string, token, uri. _lastUpdated, _createdAt search parameters and :missing modifier searches are also differs by engine.
- supported by PostgreSQL without external extensions, can be used with managed PostgreSQL, e.g. Azure PostgreSQL
- better performance for string search parameters and all string-related search (e.g. :text modifier)*
- will be supported as main engine
- is an external extension, can not be used with managed PostgreSQL
- better performance for dates, number and quantity search parameters*
BOX_SEARCH_ENGINEenvironment variable to choose engine. The default is knife.
BOX_SEARCH_ENGINE="jsonpath" # or "knife"
zen-lang is a powerful DSL language to configure Aidbox, validate profiles, and search. It allows you to set up search parameters from IGs automatically, make your own search parameters and indexes associated with them.
To enable zen-search, use
BOX_SEARCH_RESOURCE__COMPAT=falseto use preferred version of zen-search (backward compatibility environment variable).
BOX_SEARCH_RESOURCE__COMPAT=false # default is true
You can also auto-generate indexes for SearchParameter:
Token and Reference search parameters use exact match.
Aidbox uses Postgres
@>operator for this type of searches. The
@>operator is the containment operator. It checks that FHIR resource contains some subresource.
The main advantage of the
@>operator is that the single GIN index covers all token and reference searches. However sometimes Postgres planner can not build effecient query plan.
Alternatively in some cases it is possible to extract value directly using
#>>operator. This operator extracts value from the given path. There is a limitation: path must not contain any arrays.
You can configure Aidbox to prefer
@>operator using the environment variable
or using path
in Aidbox configuration project config zen symbol.
Possible values are:
@>: use the
#>>: use the
#>>operator when possible,