Search Lab Results for Abnormal values

This Report By Template will search the measurements for abnormal values (that you can enter).

<report title="Latest lab result <=> ?" description="Dr. Pun Searches for patients by recent LAB result  A1C , ie HB, PSA .CALC > 6.0 , use % for wildcard or and dataField for range value" active="1">
<query>


select * from
(
select * from (
select  l.demographicNo,
CONCAT( "<a target=new
href=../../demographic/demographiccontrol.jsp?demographic_no=",
d.demographic_no, "&displaymode=edit&dboperation=search_detail>" ,
d.demographic_no, "<a/>" ) As "Dem",
l.dateObserved,
TIMESTAMPDIFF (YEAR, concat(year_of_birth,'-',month_of_birth,'-',date_of_birth), CURDATE()) as age,
 d.last_name, d.first_name, 
l.type, l.dataField , l.comments from measurements l, demographic d   where d.patient_status = "AC" and l.demographicNo = d.demographic_no and ( l.type like '{lab}')  order by  demographic_no, dateObserved desc  ) as t1  group by demographicNo order by dateObserved  desc
) as t2 where (dataField {ac})



</query>

<param id="lab" type="text" description="Lab Test type"> </param>
<param id="ac" type="text" description="LAB test value >=<"> </param>


</report>