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 » Thu Dec 17, 2009 8:00 am

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: 5744
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: raw pop. data query error

Post by jordansparks » Thu Dec 17, 2009 1:28 pm

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 » Tue Dec 22, 2009 7:32 am

just trying to run a query

User avatar
jordansparks
Site Admin
Posts: 5744
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: raw pop. data query error

Post by jordansparks » Tue Dec 22, 2009 2:19 pm

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 » Mon Dec 28, 2009 8:02 am

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: 5744
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: raw pop. data query error

Post by jordansparks » Tue Dec 29, 2009 9:24 am

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