Can someone offer a query just to find out how many active patients there are?
Can someone offer a query to find out how many deceased patients there are?
I checked the query examples and can't seem to find anything that will give me these two reports. Thank you
Query examples
Re: Query examples
To Find Active Patients, Go to the Query Example Page
http://70.90.133.65:1942/ODQueryList/QueryList.aspx
Use Query #22.
I am sorry but I can't help you with the Query for deceased patients.
http://70.90.133.65:1942/ODQueryList/QueryList.aspx
Use Query #22.
I am sorry but I can't help you with the Query for deceased patients.
Re: Query examples
I think this might work:
SELECT patient.LName,patient.FName,patient.Address,patient.Address2,patient.City,patient.State,patient.Zip,patient.HmPhone,patient.WirelessPhone,patient.Birthdate,patient.Email,patient.MedUrgNote FROM patient
WHERE PatStatus=5
ORDER BY LName
You can customize this by eliminating patient.Address, patient.City, etc if you do not need those items.
PatStatus is broken down as 0=Patient, 1=NonPatient, 2=Inactive, 3=Archived, 4=Deleted, and 5=Deceased.
Jim
After looking, this might work better:
SELECT PatStatus,COUNT(*)FROM patient
WHERE PatStatus= 5
Group By PatStatus
Sorry for the confusion
Jim
SELECT patient.LName,patient.FName,patient.Address,patient.Address2,patient.City,patient.State,patient.Zip,patient.HmPhone,patient.WirelessPhone,patient.Birthdate,patient.Email,patient.MedUrgNote FROM patient
WHERE PatStatus=5
ORDER BY LName
You can customize this by eliminating patient.Address, patient.City, etc if you do not need those items.
PatStatus is broken down as 0=Patient, 1=NonPatient, 2=Inactive, 3=Archived, 4=Deleted, and 5=Deceased.
Jim
After looking, this might work better:
SELECT PatStatus,COUNT(*)FROM patient
WHERE PatStatus= 5
Group By PatStatus
Sorry for the confusion
Jim
James Zemencik, DMD
http://www.bridgeville-dentist.com/
http://www.bridgeville-dentist.com/
Re: Query examples
Jim
Thank you, it worked great!
Thank you, it worked great!
Re: Query examples
JayclayDDS
Thanks for the help
Thanks for the help