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
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 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
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.