Home ›

Reminder Run Report

Submitted by tony on Mon, 25/07/2011 - 10:49
in
Category: 
Reminder

This report can be used to detail when reminders have been sent using the last sent date stored on each reminder. It also provides a mechanism to list reminder run dates which some people have requested.  

The report prompts for Reminder Type and start and end date criteria and will display grouped by reverse chronological run date within the specified period.  Display customer, patient, reminder type and count (how many sent).

As always any comments appreciated.

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Reminder Run Report

Submitted by PaulDavey (not verified) on Tue, 01/09/2015 - 14:45.

Hi Tony

Can you suggest a way I can run a report to generate a list of patients that have no reminders? Just trying to tidy our database up and finding a lot of patients that for whatever reason have no reminders on their record.

 

Regards

 

Paul Davey

Re: Reminder Run Report

Submitted by tanderson on Tue, 01/09/2015 - 21:19.

The following SQL will generate a listing of patient ids and names of active patients with no reminders. It should be a straight forward exercise to turn it into a JasperReport.

select e.entity_id, e.name
from entities e
left join participations p
    on p.entity_id = e.entity_id
        and p.arch_short_name = "participation.patient"
        and p.act_arch_short_name = "act.patientReminder"
left join entity_details deceased
    on deceased.entity_id = e.entity_id and deceased.name = "deceased"
where e.arch_short_name = "party.patientpet"
    and e.active = 1
    and p.entity_id is null
    and (deceased.entity_id is null or deceased.value = 'false')
Syndicate content