Because the pseudo-event functionality incorporates a new flag to distinguish data collecting field events from rehabbing information, all queries relating to the event table must exclude pseudo-event records.
All existing queries must be adjusted to avoid including these rehab pseudo-events.
To exclude these records include a WHERE clause thus
Because the pseudo-event functionality incorporates a new flag to distinguish data collecting field events from rehabbing information, all queries relating to the event table must exclude pseudo-event records.
All existing queries must be adjusted to avoid including these rehab pseudo-events.
To exclude these records include a WHERE clause thus
WHERE PsuedoEvent = 0