Although the Biotics application itself prevents duplicate Visit records from being created, if you run SQL statements, duplicates can be created as there is no database constraint preventing duplicates. To identify duplicate records, run the following query in Query Builder:


SELECT source_feature_id, visited_by, visit_date, d_dataset_id, global_id, COUNT(*)

FROM visit

GROUP BY source_feature_id, visited_by, visit_date, d_dataset_id, global_id

HAVING COUNT(*) > 1

order by source_feature_id, visited_by


Once identified, you can manually remove the duplicate Visits from the SF record.