There is an ancient bug in REDCap, long ago fixed, that created a data bug that plagues some old REDCap projects. It causes novel pre-scheduled survey invitation reminders to not get purged after the survey is completed. This still happens on our REDCap 13.8.4 system with survey invitations created this week. We are not alone in this There are many reports of this in te REDCap community:
Whereas we don't know where the data bug is, we can see the symptoms in the form of non-deleted invitation reminders for completed surveys. These are easy to see by looking in Surveys/invite_participants.php for future invitations with completed responses. It's easy to delete them maually there as well, but as new ones are being created every day, it presents a maintance problem. They have to be deleted before a reminder to a completed survey goes out.
To reduce the burden on the REDCap admin, we propose to write a script that can locate and delete these records, then automate it to run daily.
There is an ancient bug in REDCap, long ago fixed, that created a data bug that plagues some old REDCap projects. It causes novel pre-scheduled survey invitation reminders to not get purged after the survey is completed. This still happens on our REDCap 13.8.4 system with survey invitations created this week. We are not alone in this There are many reports of this in te REDCap community:
Whereas we don't know where the data bug is, we can see the symptoms in the form of non-deleted invitation reminders for completed surveys. These are easy to see by looking in
Surveys/invite_participants.phpfor future invitations with completed responses. It's easy to delete them maually there as well, but as new ones are being created every day, it presents a maintance problem. They have to be deleted before a reminder to a completed survey goes out.To reduce the burden on the REDCap admin, we propose to write a script that can locate and delete these records, then automate it to run daily.