You are here: Home Information for OSCAR Users EMR Resources Report Templates Measurement values (yes/no)
Personal tools
Document Actions

Measurement values (yes/no)

by David Chan last modified 2007-08-16 10:07

Report on measurement values with (yes/no) values

<report  title="Measurement values (yes/no)" description="Measurement values (yes/no)" active="1">
<query>
select last_name,first_name,concat(date_of_birth,'-',month_of_birth,'-',year_of_birth) as DOB, dataField from measurements,demographic where measurements.demographicNo = demographic.demographic_no and type = '{type}' and dataField like '{keyvals}%';
</query>
<param id="type" type="list" description="Measurement Type">
<param-query>select distinct type,typeDisplayName from measurementType where validation =7;</param-query>
</param>
<param id="keyvals" type="list" description="Key Value">
<choice id="y">Yes</choice>
<choice id="n">No</choice>
<choice id="%">Nonset</choice>
</param>
</report>