intersystems-community / iris-fhir-template

MIT License
11 stars 14 forks source link

Add sql example + postman collection #4

Closed grongierisc closed 4 years ago

evshvarov commented 4 years ago

@grongierisc, let's use Fhirtemplate.SQLVar class rather than User?

grongierisc commented 4 years ago

@grongierisc, let's use Fhirtemplate.SQLVar class rather than User?

If we do so, we have to change all the sql statement from

SELECT 
ID, Key, ResourceString, 
GetJSON(ResourceString,'valueQuantity') as valueQuantity
FROM HSFHIR_I0001_R.Rsrc where Key = 'Observation/16'

To

SELECT 
ID, Key, ResourceString, 
Fhirtemplate_GetJSON(ResourceString,'valueQuantity') as valueQuantity
FROM HSFHIR_I0001_R.Rsrc where Key = 'Observation/16'

Personally, I prefer GetJSON than Fhirtemplate_GetJSON

evshvarov commented 4 years ago

Got you, fine!