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

Hi everyone, I know this post is really old, but I too would like to understand how to read the value in the “pc_recurrspec” field from the table “openemr_postcalendar_events”. Any help would be appreciated :slight_smile:

Also, why didn’t they create multiple records instead of inserting using the field? I’ve noticed that when a user creates a lot of recurring appointments the calendar slows down.