{"name": "CUSTOM-EHP-REPORT-AI-สรุปจำนวนผู้ป่วยแยกตามรหัสวินิจฉัยหลัก 10 อันดับแรก", "title": "สรุปจำนวนผู้ป่วยแยกตามรหัสวินิจฉัยหลัก 10 อันดับแรก", "landscape": false, "variables": [{"name": "date1", "prompt": "ตั้งแต่วันที่ (date1)", "sample": "2026-01-01"}, {"name": "date2", "prompt": "ถึงวันที่ (date2)", "sample": "2026-12-31"}], "dataviews": [{"name": "Master", "master": true, "params": ["date1", "date2"], "sql": "select v.pdx as pdx_code, i.name as pdx_name, count(v.vn) as patient_count from vn_stat v left join icd101 i on v.pdx = i.code where v.vstdate between :date1 and :date2 group by v.pdx, i.name order by patient_count desc limit 10"}], "columns": [{"field": "pdx_code", "caption": "รหัสวินิจฉัยหลัก", "format": null, "memo": false, "align": "taLeftJustified", "width": 25.0}, {"field": "pdx_name", "caption": "ชื่อวินิจฉัย", "format": null, "memo": false, "align": "taLeftJustified", "width": 25.0}, {"field": "patient_count", "caption": "จำนวนผู้ป่วย", "format": null, "memo": false, "align": "taLeftJustified"}], "highlight": []}