Any reason to hold onto core_occurrence_attendance records where attended = 0?Is there any value in knowing someone didn't attending something? Would deleting these records cause any harm?
Attended =0 is either left over from the conversion or from a correction on manual check in.I would say that deleting them is fine.
Wondering if the Event Tag setting, "Display this event on a person's detail page ONLY if they actually ATTEND this event", might use Attended = 0?
Deleted some 3 million records in DEV. Not seeing any adverse effects so far. Deleting the records did not cause an issue with the event tag setting "Display this event on a person's detail page ONLY if they actually ATTEND this event"
There is a notes field in core_occurrence_attendance that we would sometimes use where attended may still = 0.
For example, we recently held a class which we also made available online and we marked those that attended in person as attended, but in the notes field entered "online" if they told us they watched the class online. Our attendance chart report marks any notes as an asterisk in the grid and then lists the notes below.
So, if you wanted to clear out those entries but keep anything with notes, I would say:
WHERE attended=0 AND notes=''