From c7faa0c3d74f1a64bfab94c85500c5f1e318755e Mon Sep 17 00:00:00 2001 From: =?utf8?q?Andreas=20M=C3=BCller?= Date: Mon, 19 Dec 2011 18:37:59 +0000 Subject: [PATCH] add filters to E+M activator --- .../java/eu/etaxonomy/cdm/app/pesi/EuroMedActivator.java | 6 ++++++ 1 file changed, 6 insertions(+) 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 5932286e..fbee7bf4 100644 --- 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,6 +89,9 @@ public class EuroMedActivator { static String referenceFilter = "SELECT refId FROM v_cdm_exp_allReferences"; + static String factFilter = " FactID IN (SELECT factID FROM fact f " + + " INNER JOIN v_cdm_exp_allTaxa t ON f.PTNameFk = t.PTNameFk AND f.PTRefFk = t.PTRefFk )"; + @@ -189,6 +192,9 @@ public class EuroMedActivator { config.setTaxonTable(taxonTable); config.setClassificationQuery(classificationQuery); config.setRelTaxaIdQuery(relPTaxonIdQuery); + config.setNameIdTable(nameIdTable); + config.setReferenceFilter(referenceFilter); + config.setFactFilter(factFilter); config.setCheck(check); -- 2.34.1