Completed reminders not showing ?? IT DOES

Submitted by Guest on Fri, 01/03/2013 - 12:05

Implementation discussion

THIS IS WRONG - SEE LAST COMMENT AT BOTTOM.

Version 1.6. The display of reminders for a given patient does not show Completed reminders. See the screen shot below. However, the following SQL does show completed reminders present:
select * from participations p
inner join acts a on p.act_id = a.act_id
inner join entities e on p.entity_id = e.entity_id
where p.arch_short_name ='participation.patient' and
a.arch_short_name = 'act.patientReminder'
order by e.entity_id;

Isolating the data for the patient in the screen shot we have:

description	activity_start_time	activity_end_time	status	entity_id	name
Due Date : 03/08/2011 Reminders Sent : 1	3/08/2011 0:00	3/08/2011 0:00	COMPLETED	297	D D Chai
Due Date : 07/08/2012 Reminders Sent : 4	7/08/2012 0:00	7/08/2012 0:00	COMPLETED	297	D D Chai
Due Date : 03/08/2011 Reminders Sent : 3	3/08/2011 0:00	3/08/2011 0:00	COMPLETED	297	D D Chai
Due Date : 03/12/2012 Reminders Sent : 2	3/12/2012 0:00	3/12/2012 0:00	COMPLETED	297	D D Chai
Due Date : 05/04/2011 Reminders Sent : 1	5/04/2011 0:00	5/04/2011 0:00	COMPLETED	297	D D Chai
Due Date : 06/01/2014 Reminders Sent : 0	6/01/2013 17:37	6/01/2014 0:00	IN_PROGRESS	297	D D Chai
Due Date : 06/01/2014 Reminders Sent : 0	6/01/2013 17:37	6/01/2014 0:00	IN_PROGRESS	297	D D Chai
Due Date : 06/07/2013 Reminders Sent : 0	6/01/2013 17:37	6/07/2013 0:00	IN_PROGRESS	297	D D Chai
Due Date : 09/04/2014 Reminders Sent : 0	9/04/2011 16:05	9/04/2014 0:00	IN_PROGRESS	297	D D Chai

As you can see, although all the In Progress ones are displayed, none of the Completed ones are show.

Is this something I have screwed up in the conversion, or is this a bug in the reminder display logic?

Regards, Tim G

Re: Completed reminders not showing ??

Submitted by bencharlton (not verified) on Fri, 01/03/2013 - 12:20.

I confirm this is present in our production system where the reminders where completed within openvpms. Suspect its the display logic !

Re: Completed reminders not showing ??

Submitted by tgething (not verified) on Fri, 01/03/2013 - 14:27.

Yes I agree that its the display logic. However, its subtle. I just ran the reminder processing and then looked at the same patient. As you can see, now the completed ones now show up!