ORALZY
Feature

Query Builder kya hai aur kahan milta hai?

Insights → Clinic Health → Query Builder ("Custom Query Builder") — bina formula ke clinic ka data list me nikaalne ka tool. Baayein "Collections" me ek chuno: appointments, bills, doctors, expenses, journal, patients, payments, treatments → "Run" → "Results: N rows" table → "CSV" se download.

Where in ORALZY: Insights → Clinic Health → Query Builder

Sirf owner / admin ke liye — doosre role ko data nahi milta. Har "Run" clinic ke access log me "export" ki tarah likha jaata hai (kisne, kitni rows). Ek baar me "Limit" jitni rows (default 100, zyada se zyada 5,000), sabse nayi pehle. Table me pehli 200 rows dikhti hain; baaki CSV me. Patients me naam, phone, email, address jaise column aate hain, isliye CSV sambhal kar rakho. Bills / payments / treatments me patient aur doctor ka naam nahi, sirf unka ID column aata hai. Ye Core plan me hai, AI credit nahi lagta.

Quick steps

  1. Insights → Clinic Health → Query Builder kholo
  2. Baayein "Collections" me data chuno (jaise patients ya bills)
  3. "Run" dabao
  4. "CSV" se file download karo

querybuildercustomreportdatanikalnacollectionsuchi