improve facts filter for BM import

diff --git a/cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/EuroMedActivator.java b/cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/EuroMedActivator.java
index fbee7bf4e5b41b188a0507faa641fc3fc5b5f54c..189c74b9fb859b8db6845b94ee7e83eb40e77a7a 100644 (file)
--- a/cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/EuroMedActivator.java
+++ b/cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/EuroMedActivator.java
@@ -89,8 +89,7 @@ public class EuroMedActivator {
        \r
        static String referenceFilter = "SELECT refId FROM v_cdm_exp_allReferences";\r
        \r
-       static String factFilter = " FactID IN (SELECT factID FROM fact f " +\r
-                       " INNER JOIN v_cdm_exp_allTaxa t ON f.PTNameFk = t.PTNameFk AND f.PTRefFk = t.PTRefFk )";\r
+       static String factFilter = " SELECT factId FROM v_cdm_exp_factsAll ";\r
        \r
        \r
        \r