SergeyMosin
Humans are fallible
Oh how great it would have been to have a way to check if any user has forgotten to confirm their appointment! This would prevent absent-minded people from traveling to the appointment for nothing and being upset with me when I did nothing wrong.
It's really annoying to have people who forget to confirm the appointment by email and who come when we don't expect them. Would it be possible to have at least the name of the table where the appointments awaiting validation are located, so that I can write a small script to see the unconfirmed appointments. Thank you very much
@ps6chopatrick There is a bug that sets the wrong status for pending appointments that is blocking this issue. Because of this bug the data in the oc_appointments_hash table can not be easily used for this purpose at the moment. I am planning on fixing the bug for the next release (most likely next week), and confirmation reminders and/or auto-cancel for not confirmed would be next.
However, if you really need this, you can directly query the Calendar App's oc_calendarobjects table for calendardata(ics) object
Something like this should work:
SELECT calendardata FROM oc_calendarobjects
WHERE calendardata LIKE '%PRODID:-//IDN nextcloud.com//Appointments App%ATTENDE%PARTSTAT=NEEDS-ACTION%'
Auto-cancel unconfirmed appointments after option is available in v2.4.0