MRN conversion using a SQL database for lookup

I am trying to do an MRN conversion on incoming DICOM files using a SQL lookup table.

Can anyone give me help with this?



Your question is unclear. Orthanc provides no access using the SQL language, but with its REST API:

You are presumably looking for the URI “/tools/find”:

For instance, the following request will look for patients with given “PatientID”:

curl -X POST http://localhost:8042/tools/find -d ‘{“Level”:“Patient”,“Expand”:true,“Query”:{“PatientID”:“12345678”}}’