I think that the missing records have been accidentally overwritten by an unexpected bulk copy/paste. But I don’t understand why this happened … it just doesn’t make sense to overwrite them since they were not related to the specific filter that was chosen, but then again the records are missing !
Do you have any suggestions of how you can resolve this overwriting issue without having to restore a snapshot and avoid going through the hassle of copy pasting back to the main base ?
You could check the base trash to see if any records were deleted in the last 7 days. If so, you could restore the records.
Otherwise, if the records are still there but were just overwritten with new data, you can look at each record individually to see its individual activity log. That might shed some light on how it was overwritten.
There is no easy way to get the old data back, but you could export the data from a snapshot to a CSV file and then re-import the data using the CSV import extension. You would need to match the data on a unique field (if you have one) to merge records instead of adding new records. If you don’t have a unique field, then the process would be much much harder.