Project

General

Profile

« Previous | Next » 

Revision 6e9517ee

Added by Andreas Müller almost 10 years ago

update validation

View differences:

app-import/src/main/java/eu/etaxonomy/cdm/io/berlinModel/in/validation/BerlinModelTaxonImportValidator.java
84 84
			Source source = config.getSource();
85 85
			String strSQL = " SELECT * "  +
86 86
				" FROM PTaxon t " +
87
					" INNER JOIN Name ON t.PTNameFk = Name.NameId " +
87
					" INNER JOIN Name n ON t.PTNameFk = n.NameId " +
88 88
				" WHERE (t.DoubtfulFlag = 'i') ";
89 89
			
90 90
			if (StringUtils.isNotBlank(config.getTaxonTable())){
91
				strSQL += String.format(" AND (t.RIdentifier IN " +
91
				strSQL +=  String.format(" AND (t.RIdentifier IN " +
92 92
                        " (SELECT RIdentifier FROM %s ))" , config.getTaxonTable()) ; 
93 93
			}
94
			strSQL += " ORDER BY t.ptRefFk, n.FullNameCache";
94 95
			
95 96
			ResultSet rs = source.getResultSet(strSQL);
96 97
			boolean firstRow = true;

Also available in: Unified diff