Well you can have more than one cursor. The main problem is in the second query, we joined Ens.Messageheader to EnsLib_HL7.Message and referencing the Identifier field of EnsLib_HL7.Message was causing a compiler error on the SQL query. Once that field was removed, everything is fine. The oddity is the query would work fine on the Management Portal SQL web page, but would not work in code.

The error was  multiple Referenced macro not defined errors.

Adapting the sample code to connect to my own local IRIS, how do I define the location for intersystems-iris-native. I see this line of code const irisnative = require('intersystems-iris-native'). Do I need to make a copy of one of the iris.node files from the bin directory and add it it node-modules?

Also I am using node v13.8.0 - will iris1000.node work is do I need one specific to that version?

When I run the docker up command from VSCode or if I try to run this from the command line I am getting the following error: docker.credentials.errors.InitializationError: docker-credential-gcloud not installed or not available in PATH

David

Is the current R4 support built into the FHIR Repository or is this represented somewhere else? Do you have any documentation?

Is there any plan to get rid of the intermediate data model and support FHIR data model directly, or is SDA3 still your approach to supporting it?

Also, do you have a time table for when STU4 support will be available  in 2020.1?

David