search

SIB-Colombia / sib-dataportal

Personalisation of the GBIF Dataportal v1 for the Nationational Biodiversity Information System of Colombia
http://data.sibcolombia.net
0 stars 3 forks source link

More indexed records than published #115

Closed danipilze closed 9 years ago

danipilze commented 10 years ago

This may be a content issue

There are more indexed records than published in the IPT

This may be caused because of the deletion of published records and the change of the institution code and catalogue number of the new ones published

Deleted records in the publication should be detected and marked as deleted

captura de pantalla 2013-12-17 a la s 17 28 38

danipilze commented 9 years ago

fixed with

delete from occurrence_record  
where data_resource_id=4 
and id NOT IN (select r.id from raw_occurrence_record r where r.data_resource_id=4);

Query OK, 24462 rows affected (15.07 sec)