Personal tools
You are here: Home / OSCAR Users / EMR and Case Management Resources / Report Templates / Free Text Search
Navigation
 

Free Text Search

Provided By Ian Pun

Plain Text icon Free Text Seach template.txt — Plain Text, 489 bytes

File contents

<report title="Search prevention Notes" description="Search ALL database for vaccine lot" active="1">
   <query>
        select d.last_name, d.first_name, p.prevention_date, l.val
        from preventionsExt l, demographic d, preventions p
        where p.demographic_no = d.demographic_no  and l.prevention_id = p.id and p.deleted = 0 and ( l.val like '%{search}%') order by d.last_name;
  </query>
<param id="search" type="text" description="Search for:">   </param>
</report>

Document Actions

 

Download button

DOWNLOAD OSCAR FOR TESTING

 

eForms button

DOWNLOAD SHARED E-FORMS


 Customize button

FIND PLUG-INS AND TWEAKS
FOR YOUR OSCAR EMR

 

Subscribe Button

SUBSCRIBE TO DISCUSSION LIST 
(SEE ALL LISTS)

  

Help button

ACCESS THE ONLINE MANUALS
(PAID SUPPORT)