Personal tools
You are here: Home / OSCAR Users / EMR and Case Management Resources / Query By Example - Database Searches / Oscar Usage Query By Example
 

Oscar Usage Query By Example

Provided by Ian Pun - Say your provider number OSCAR is 999998 (change it to your actual provider number) Copy and paste this SQL query into ADMIN->Query by Examples SELECT date(dateTime) as date , COUNT(1) AS count FROM log where provider_no = 999998 and action = "read" GROUP BY date , provider_no; will return a list of dates with number of charts read per day COPY and PASTE to Microsoft EXCEL to chart. Modify the sql to limit by date, action (log in, add , read, log out, failed) etc, . Maybe someone on the list can convert it to a report by template. Now you have evidence you are an OSCAR addict with hundreds of transactions a day. Ian PUN

Plain Text icon Oscar Usage by Provider Number.txt — Plain Text, 138 bytes

File contents

SELECT date(dateTime) as date ,  COUNT(1) AS count
FROM log
where provider_no = 999998 and action = "read"
GROUP BY date , provider_no;

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)