Revision 817f2688
Added by Patrick Plitzner over 7 years ago
| app-import/src/main/java/eu/etaxonomy/cdm/io/redlist/gefaesspflanzen/RedListGefaesspflanzenImportClassification.java | ||
|---|---|---|
| 63 | 63 |
|
| 64 | 64 |
@Override |
| 65 | 65 |
protected String getIdQuery(RedListGefaesspflanzenImportState state) {
|
| 66 |
return "SELECT NAMNR "
|
|
| 66 |
return "SELECT SEQNUM "
|
|
| 67 | 67 |
+ "FROM V_TAXATLAS_D20_EXPORT t " |
| 68 |
+ " ORDER BY NAMNR";
|
|
| 68 |
+ " ORDER BY SEQNUM";
|
|
| 69 | 69 |
} |
| 70 | 70 |
|
| 71 | 71 |
@Override |
| 72 | 72 |
protected String getRecordQuery(RedListGefaesspflanzenImportConfigurator config) {
|
| 73 | 73 |
String result = "select distinct e.*, f.FAMILIE " |
| 74 | 74 |
+ "from V_TAXATLAS_D20_EXPORT e, GATTUNG_FAMILIE f " |
| 75 |
+ "where e.EPI1 = f.GATTUNG and e.NAMNR IN (@IDSET)";
|
|
| 75 |
+ "where e.EPI1 = f.GATTUNG and e.SEQNUM IN (@IDSET)";
|
|
| 76 | 76 |
result = result.replace("@IDSET", IPartitionedIO.ID_LIST_TOKEN);
|
| 77 | 77 |
return result; |
| 78 | 78 |
} |
Also available in: Unified diff
#5448 Use SEQNUM as id column