Reoccuring appointments and the openemr_postcalendar_events table

Is there a reason why reoccurring appointments don’t post to the openemr_postcalendar_events table? I can see the appointments on the calendar but when I try to pull an sms reminder using a query that pulls from this table, they don’t show up.

These are the steps I took. I created a reoccuring appointment, then tried finding matching dates in that table. No entries. I created a normal appointment and an entry appears.

I am doing more testing and will update this thread as I get more info.

hi @growlingflea, pretty sure the recurring appointments have just one record in that table with a field that does the date generation that the calendar is able to parse

1 Like

hi do you know by any chance how to read the recurrspec field ? or if you could point me to documentation thatd be great. new to openEMR and i wasnt able to find it in the docs.

hi @jmm72011 that would be like being able to speak modem or read bar code :slight_smile:

you could try to decipher it from openemr/add_edit_event.php at master · openemr/openemr · GitHub and send out an :sos: to @epsdky

1 Like