Hello OD friends-
It'd be nice if we could have the option to save queries of the same name and have them replace the current version.
For example, I use
SELECT referral.LName as RefLName, referral.FName as RefFName, patient.LName as PatLName, patient.FName as PatFName, patient.Gender as Sex, referral.Title as RefTitle, referral.Address as RefAddress,referral.Address2 as RefAddress2, referral.City as RefCity, referral.ST as RefST, referral.Zip as RefZip
FROM patient,referral,refattach
WHERE patient.PatNum=refattach.PatNum
AND referral.ReferralNum=refattach.ReferralNum
AND refattach.IsFrom='1'
AND refattach.RefDate >= '2007-10-01'
AND refattach.RefDate < '2007-12-31'
AND referral.NotPerson = '0'
ORDER BY RefLName, RefFName
and so I will occasionally have to go in and change refattach.RefDate to a more recent date to cut down on the size of the exported list.
Right now, I have to 'Add to Favorites' and then go in and delete the prior version. It sure would simplify things if I had a 'Save Query' button (with a popup asking if I want to replace previous version) to speed things along.
Happy Halloween!
'Save Query' option
'Save Query' option
Cheers,
Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA
Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA
Because then I have fiddle with it every time I run the query, which is multiple times throughout the day.
Besides, one should always have 'Save' and 'Save As' options. It pretty much expected behavior
Besides, one should always have 'Save' and 'Save As' options. It pretty much expected behavior
Cheers,
Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA
Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA
- jordansparks
- Site Admin
- Posts: 5746
- Joined: Sun Jun 17, 2007 3:59 pm
- Location: Salem, Oregon
- Contact:
I know the behavior of that section is old and annoying. But it's low priority.
Jordan Sparks, DMD
http://www.opendental.com
http://www.opendental.com
I made a small change to your query so you don't have to go in and change the dates all the time. It will now calculate a period of time of 3 months (today minus a 3 month interval) so every day you can get the previous 3 months' referrals. I used a 3 month interval, but you can change that to whatever you want:
SELECT referral.LName as RefLName, referral.FName as RefFName, patient.LName as PatLName, patient.FName as PatFName, patient.Gender as Sex, referral.Title as RefTitle, referral.Address as RefAddress,referral.Address2 as RefAddress2, referral.City as RefCity, referral.ST as RefST, referral.Zip as RefZip
FROM patient,referral,refattach
WHERE patient.PatNum=refattach.PatNum
AND referral.ReferralNum=refattach.ReferralNum
AND refattach.IsFrom='1'
AND refattach.RefDate > curdate() - INTERVAL 3 MONTH
AND referral.NotPerson = '0'
ORDER BY RefLName, RefFName
Jorge Bonilla, DMD
SELECT referral.LName as RefLName, referral.FName as RefFName, patient.LName as PatLName, patient.FName as PatFName, patient.Gender as Sex, referral.Title as RefTitle, referral.Address as RefAddress,referral.Address2 as RefAddress2, referral.City as RefCity, referral.ST as RefST, referral.Zip as RefZip
FROM patient,referral,refattach
WHERE patient.PatNum=refattach.PatNum
AND referral.ReferralNum=refattach.ReferralNum
AND refattach.IsFrom='1'
AND refattach.RefDate > curdate() - INTERVAL 3 MONTH
AND referral.NotPerson = '0'
ORDER BY RefLName, RefFName
Jorge Bonilla, DMD
Nice- thanks!
Cheers,
Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA
Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA