Personal tools
You are here: Home OSCAR Users EMR and Case Management Resources Report Templates Measurement values (yes/no)

Measurement values (yes/no)

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>
Document Actions
Help us support OSCAR!
Listservs

Subscribe to:

OSCAR Users (this is the most active list)

Medical Office Assistants

Developers

Listserv Archives

Membership

OSCAR users- please register with the OSCARcanada Users Society. There is no cost to be a member of the OSCARcanada Users Society and you will receive periodic updates about important OSCAR developments, news and meetings. Members are also be able to vote at the AGM

Contact Us

Oscar Canada Users Society

#425 - 1917 West 4th Avenue

Vancouver  BC  V6J 1M7

OscarCanadaUserSociety@gmail.com