Постман коллекция: Информация о пациенте.postman_collection.json
Ссылки на переменные окружения
Блок кода | ||||||
---|---|---|---|---|---|---|
| ||||||
-- в цоде declare @@listOfIDs table (id int); insert @@listOfIDs(id) select mkabid from hlt_mkab with(nolock) where UGUID IN(@0); -- мкабы пациента select mkb.name as [Name], mkb.DS as [Code] from hlt_TAP t with(nolock) join oms_kl_DiseaseType dt with(nolock) on t.rf_kl_DiseaseTypeID = dt.kl_DiseaseTypeID join Oms_mkb mkb with(nolock) on t.rf_MKBID = mkb.mkbid where t.rf_MKABID in (select id from @@listOfIDs) and dt.code = '1' and t.rf_MKBID != 0 union select mkb.name as [Name], mkb.DS as [Code] from hlt_TAP t with(nolock) join oms_kl_DiseaseType dt with(nolock) on t.rf_kl_DiseaseType2ID = dt.kl_DiseaseTypeID join Oms_mkb mkb with(nolock) on t.rf_MKB2ID = mkb.mkbid where t.rf_MKABID in (select id from @@listOfIDs) and dt.code = '1' and t.rf_MKB2ID != 0 |
...