HiEventsDev
🌟Check-In Time: Record the exact time when an attendee checks in
ℹ️ Please check if the feature you're requesting already exists in the project's roadmap or issues.
Is your feature request related to a problem? Please describe. Unable to find the check-in time for each attendee.
Describe the solution you'd like Display the check-in time and checkout-time for each attendee
Additional context
Good suggestion! Thank you. This data is stored in the DB, so it will be easy to display.
the current version doesn't seem to record the check-in time in the attendees table.
Good suggestion! Thank you. This data is stored in the DB, so it will be easy to display.
Is it a bug? Should I create a bug report?
@trashken Those columns relate to the deprecated check-in endpoints. There's another table that stores the check-in list data. I'm currently away from my laptop so I can't recall the exact name of the table
@trashken Those columns relate to the deprecated check-in endpoints. There's another table that stores the check-in list data. I'm currently away from my laptop so I can't recall the exact name of the table
Do you mean attendee_check_ins? It doesn't have a timestamp for check-ins only timestamps for creation and last_update.
You can infer the check-in time from the created date. There's no need for an explicit "check-in" timestamp.
SELECT a.first_name, a.last_name, b.updated_at::timestamp at time zone 'UTC' at time zone '<your time zone>' FROM attendees a JOIN attendee_check_ins b ON b.attendee_id = a.id ORDER BY a.first_name ASC
Yes.. I am using the SQL above to get the times in my time-zone. Would be great if it was a report or somewhere for organizers to see who was early, on-time and late. Thanks.
@trashken It has been requested a few times, so I'll add it into the next major version.