Revision 31e71264
Added by Andreas Müller over 5 years ago
| app-import/src/main/java/eu/etaxonomy/cdm/app/berlinModelImport/EuroMedActivator.java | ||
|---|---|---|
| 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 = null; //*/ " authorTeamId IN (SELECT authorTeamId FROM v_cdm_exp_authorTeamsAll) ";
|
|
| 187 |
static String authorFilter = null; //*/ " authorId IN (SELECT authorId FROM v_cdm_exp_authorsAll) ";
|
|
| 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) ";
|
|
| 188 | 188 |
|
| 189 | 189 |
|
| 190 | 190 |
|
Also available in: Unified diff
ref #7799 improve performance of authorteam loading