Re: [Oscarmcmaster-bc-moa] Query help!

[gaetzfamilypractice <gae...@sh...>]

Thank you! That one is great but... does anyone know how to look up patients who have NOT had one done in the last 6 months?

----- Original Message -----
From: Dr Gill <drs...@sh...>
Date: Friday, May 28, 2010 1:48 pm
Subject: Re: [Oscarmcmaster-bc-moa] Query help!

> Copy and paste this into notepad.
> 
> 
> 
> <report title="HbA1C lookup" description="Searches for patients by 
> recentHbA1C result" active="1">
> <query>
> select distinct demo.last_name,demo.first_name,dataField 
> ,dateObserved from
> measurements, demographic demo where type ="A1C" and dataField > 
> {ac} and
> demo.patient_status = 'AC' and dateObserved >
> ((PERIOD_ADD(EXTRACT(YEAR_MONTH FROM CURDATE()),-{mon})*100)+1)  and
> demographicNo =demo.demographic_no order by 
> demo.last_name,demo.first_name;</query>
> 
> <param id="ac" type="text" description="HbA1C greater than"> </param>
> <param id="mon" type="text" description="Within the last 
> (months)"> </param>
> 
> </report>
> 
> 
> Add as template (report by template under admin)
> 
> When you run the template you can specify the # of months and the A1c.
> 
> Sabrina
> 
> -----Original Message-----
> From: gaetzfamilypractice [mailto:gae...@sh...] 
> Sent: May 28, 2010 1:38 PM
> To: 'MOA discussion list'
> Subject: [Oscarmcmaster-bc-moa] Query help!
> 
> Dr. Harder would like to run a query for "Diabetic patients who 
> have not had
> a HgbA1c done in the past 6 months". None of us here are THAT computer
> savvy. Does anyone have a similar query? Or do you know how to do 
> this?
> Thanks!
> 
> Gaetz Family Practice
> 
> -------------------------------------------------------------------
> ---------
> --
> 
> _______________________________________________
> Oscarmcmaster-bc-moa mailing list
> Osc...@li...
> https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-bc-moa
> No virus found in this incoming message.
> Checked by AVG - www.avg.com 
> Version: 8.5.437 / Virus Database: 271.1.1/2901 - Release Date: 
> 05/28/1006:25:00
> 
> 
> -------------------------------------------------------------------
> -----------
> 
> _______________________________________________
> Oscarmcmaster-bc-moa mailing list
> Osc...@li...
> https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-bc-moa
>