Premium email support fee            $30 per person / $60 per family per year.

includes unlimited email support/ virtual video visits for whole year/ lab results emailed.

<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, fixed for WELLPRO" 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})  limit 50;

</query>

<param id="lab" type="text" description="Lab Test type"> </param>

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

</report>