Scheduler Reminders

SOS Blog

13 years ago

“Is there an easy query that would simply print all the scheduler reminders off the patient info form p.2?”

SELECT 
   LastName, 
   FirstName, 
   ID, 
   NoSchedReason
FROM 
   sos.Patients
WHERE 
   Flag = 0
ORDER BY 
   LastName, 
   FirstName

The Flag condition limits to active patients. If you want only those that have a reminder entered, add another condition. 
Note that the '' at the end of line three is two apostrophes, not a single quotation mark.

SELECT 
   LastName, 
   FirstName, 
   ID, 
   NoSchedReason
FROM 
   sos.Patients
WHERE 
   Flag = 0 
   AND NoSchedReason <> ''
ORDER BY 
   LastName, 
   FirstName

 Finally, the one below combines the name and id into a single field to make the output a bit cleaner:

SELECT 
   LastName+', '+ FirstName+' / '+ ID AS "Patient", 
   NoSchedReason
FROM 
   sos.Patients
WHERE 
   Flag = 0 
   AND NoSchedReason <> ''
ORDER BY 
   LastName, 
   FirstName