Abnormal labs in a ward, today
curl -X POST https://oc-acme.ap-south-1.originchain.ai/v1/sql \
-H "Authorization: Bearer $OC_TOKEN" \
-H "Content-Type: application/json" \
-d '{"sql":"SELECT p.patient_ref, p.bed_id, l.test, l.value FROM patients p JOIN labs l ON l.patient_ref = p.patient_ref WHERE p.ward = ''ICU-3'' AND l.ts > date_trunc(''day'', now()) AND NOT (l.value BETWEEN l.ref_low AND l.ref_high)"}' {
"rows": [
{ "patient_ref": "P-48317", "bed_id": "ICU-3-07", "test": "K+", "value": 5.9 },
{ "patient_ref": "P-48401", "bed_id": "ICU-3-12", "test": "lactate", "value": 4.2 }
],
"meta": { "latency_ms": 48 }
}