raw pop. data query error

For users or potential users.
Post Reply
spearfishdentist
Posts: 10
Joined: Sun Jul 20, 2008 4:21 pm

raw pop. data query error

Post by spearfishdentist »

latest version 6.8.27

any type of adjustment i select gives me the following error:

Invalid query: Unknown column 'GradeSchool' in field list
User avatar
jordansparks
Site Admin
Posts: 5776
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: raw pop. data query error

Post by jordansparks »

Could you be a little more specific? Are you trying to add an adjustment in the account module of a patient?

Or are you trying to run a report of some kind?
Jordan Sparks, DMD
http://www.opendental.com
spearfishdentist
Posts: 10
Joined: Sun Jul 20, 2008 4:21 pm

Re: raw pop. data query error

Post by spearfishdentist »

just trying to run a query
User avatar
jordansparks
Site Admin
Posts: 5776
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: raw pop. data query error

Post by jordansparks »

Which query? Is it the raw patient report? Or if it's from our query examples list, which number?
Jordan Sparks, DMD
http://www.opendental.com
spearfishdentist
Posts: 10
Joined: Sun Jul 20, 2008 4:21 pm

Re: raw pop. data query error

Post by spearfishdentist »

reports -> raw population data -> Nov 1-Nov 30 with Broken Appt - No Show and BROKEN Appt w/o 24 hours selected.
User avatar
jordansparks
Site Admin
Posts: 5776
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: raw pop. data query error

Post by jordansparks »

Ah, a public health report. I have put it down as a bug. You realize that most dental offices would never need that report, right? It's just for public health clinics. Still, it will be fixed shortly.
Jordan Sparks, DMD
http://www.opendental.com
Post Reply