Message from paul.stadler@gmail.com paul.stadler@gmail.com

My present guess on this is to identify the reminders using this:

select * from acts inner join act_details on act_details.act_id=acts.act_id
and act_details.name='reminderCoutn' where
arch_short_name='act.patientReminder' and
DATE(activity_end_time)>DATE("startdate") and
DATE(activity_end_time)0
... and update the act_details.value to be 0. This won't change the
description field however... where there's a string representation of how
many times it has been sent. I may need to repopulate that field as well.

Cheers, Paul

_______________________________________________
OpenVPMS User Mailing List
users@lists.openvpms.org
To unsubscribe or change your subscription visit:
http://lists.openvpms.org/listinfo/users
Posts from this mailing list can be viewed online and replied to in the OpenVPMS User's forum- http://tinyurl.com/openvfu