HbA1c Lookup
Searches for patients by recent HbA1C result
HbA1c lookup.txt
—
Plain Text,
0Kb
File contents
<report title="HbA1C lookup" description="Searches for patients by recent HbA1C 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>
