Постман коллекция: Информация о пациенте.postman_collection.json
Ссылки на переменные окружения
Блок кода | ||||||
---|---|---|---|---|---|---|
| ||||||
-- в цоде select so.Date as [DateBegin], so.DataEnd as [DateEnd], sm.ServiceMedicalCode as [Code], sm.ServiceMedicalName as [Name], op.Name as [TypeName], op.Code as [TypeCode] from stt_MedicalHistory mh with(nolock) join stt_SurgicalOperation so with(nolock) on so.rf_MedicalHistoryID = mh.MedicalHistoryID left join oms_ServiceMedical sm with(nolock) on sm.ServiceMedicalID = so.rf_kl_ServiceMedicalID left join stt_Operation op with(nolock) on op.OperationID = so.rf_OperationID where mh.rf_mkabid in (select mkabid from hlt_mkab with(nolock) where UGUID IN(@0)) -- мкабы пациента |
...