Revision 817f2688
Added by Patrick Plitzner over 7 years ago
| app-import/src/main/java/eu/etaxonomy/cdm/io/redlist/gefaesspflanzen/RedListGefaesspflanzenImportAuthor.java | ||
|---|---|---|
| 47 | 47 |
|
| 48 | 48 |
@Override |
| 49 | 49 |
protected String getIdQuery(RedListGefaesspflanzenImportState state) {
|
| 50 |
return "SELECT NAMNR "
|
|
| 50 |
return "SELECT SEQNUM "
|
|
| 51 | 51 |
+ "FROM V_TAXATLAS_D20_EXPORT t " |
| 52 |
+ " ORDER BY NAMNR";
|
|
| 52 |
+ " ORDER BY SEQNUM";
|
|
| 53 | 53 |
} |
| 54 | 54 |
|
| 55 | 55 |
@Override |
| 56 | 56 |
protected String getRecordQuery(RedListGefaesspflanzenImportConfigurator config) {
|
| 57 | 57 |
String result = " SELECT * " |
| 58 | 58 |
+ " FROM V_TAXATLAS_D20_EXPORT t " |
| 59 |
+ " WHERE t.NAMNR IN (@IDSET)";
|
|
| 59 |
+ " WHERE t.SEQNUM IN (@IDSET)";
|
|
| 60 | 60 |
result = result.replace("@IDSET", IPartitionedIO.ID_LIST_TOKEN);
|
| 61 | 61 |
return result; |
| 62 | 62 |
} |
Also available in: Unified diff
#5448 Use SEQNUM as id column