Query Builder sirf owner / admin ke liye hai aur har run access log me 'export' ki tarah likha jaata hai. Abhi field / filter dropdown khaali hain aur filter server par lagta nahi, isliye har run poori list deta hai (sabse naye pehle, max 5,000). Isliye 'sirf RGHS patients jinke bill ₹10,000 se upar' jaisa sawal CSV ko Excel me filter karke hi niklega. Bills ki list me patient ka naam nahi, sirf ID aata hai. Jo field app me kabhi bhara hi nahi, wo CSV me bhi khaali aayega.
Report me wo column/filter nahi jo mujhe chahiye — apni report kaise banau?
Insights → Clinic Health → Query Builder ("Custom Query Builder") — data list (patients, bills, payments, appointments, treatments, expenses, doctors, journal) chuno → "Limit" → "Run" → "CSV" download karke Excel / Sheets me apne filter lagao. Seedha sawal poochhna ho to Veeransh se poocho.
Where in ORALZY: Insights → Clinic Health → Query Builder
Quick steps
- Insights → Clinic Health → Query Builder kholo
- Data (patients, bills…) chuno aur "Limit" bharo
- "Run" phir "CSV"
- CSV ko Excel / Sheets me filter karo