Project

General

Profile

Revision b154ea92

IDb154ea92aba196ce8c621c782245ee576dc0e5e4
Parent 274e96c0
Child db652f5c

Added by Andreas Müller about 3 years ago

include filtered authors in E+M import

View differences:

app-import/src/main/java/eu/etaxonomy/cdm/app/berlinModelImport/EuroMedActivator.java
106 106
    static final boolean doFacts = true;
107 107
    static final boolean doRelTaxa = true;
108 108
    static final boolean doOccurrences = false;
109
    static final boolean doOccurrenceSources = true;
110
    static final boolean doCommonNames = true;  //currently takes very long
109
    static final boolean doOccurrenceSources = false;
110
    static final boolean doCommonNames = false;  //currently takes very long
111 111

  
112 112
  //serious types do not exist in E+M except for name types which are handled in name relations
113 113
    static final boolean doTypes = false;  //serious types do not exist in E+M except for name types which are handled in name relations
......
183 183
	static String occurrenceSourceFilter = " occurrenceFk IN ( SELECT occurrenceId FROM v_cdm_exp_occurrenceAll )";
184 184
	static String commonNameFilter = " commonNameId IN ( SELECT commonNameId FROM v_cdm_exp_commonNamesAll )";
185 185
	static String webMarkerFilter = " TableNameFk <> 500 OR ( RIdentifierFk IN (SELECT RIdentifier FROM v_cdm_exp_taxaAll)) ";
186
	static String authorTeamFilter =  " authorTeamId IN (SELECT drvTmp.authorTeamId FROM (SELECT authorTeamId FROM v_cdm_exp_authorTeamsAll) as drvTmp) ";
187
	static String authorFilter = null; //  " authorId IN (SELECT authorId FROM v_cdm_exp_authorsAll) ";
186
	static String authorTeamFilter =  " authorTeamId IN (SELECT drvTab.authorTeamId FROM (SELECT authorTeamId FROM v_cdm_exp_authorTeamsAll) as drvTab) ";
187
	static String authorFilter = " authorId IN (SELECT drvTab.authorId FROM (SELECT authorId FROM v_cdm_exp_authorsAll) as drvTab) ";
188 188

  
189 189

  
190 190

  

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)