set indices in json - Githubissues

miracum / fhir-gateway

A thin layer between FHIR REST clients and resource processing pipelines.

Apache License 2.0

13 stars 7 forks source link

set indices in json #42

Open kapsner opened 2 years ago

kapsner commented 2 years ago

For better performance, set indices on json-items to enhance user-experience and speed when joining:

Patient-ID, e.g.:

Patient.DATA ->> 'id'
REPLACE(jsonb_path_query(Encounter.DATA, '$.subject') ->> 'reference', 'Patient/', '')

Encounter-ID, e.g.:

Encounter.DATA ->> 'id'
REPLACE(Condition.DATA -> 'encounter' ->> 'reference', 'Encounter/', '')
REPLACE(Procedure.DATA -> 'encounter' ->> 'reference', 'Encounter/', '')
REPLACE(Observation.DATA -> 'encounter' ->> 'reference', 'Encounter/', '')