Project

General

Profile

« Previous | Next » 

Revision c68501f4

Added by Andreas Müller over 9 years ago

Refine RelTaxonValidation

View differences:

app-import/src/main/java/eu/etaxonomy/cdm/io/berlinModel/in/validation/BerlinModelTaxonRelationImportValidator.java
207 207
					" INNER JOIN RelPTQualifier ON RelPTaxon.RelQualifierFk = RelPTQualifier.RelPTQualifierId " +
208 208
					" LEFT OUTER JOIN Name ON PTaxon.PTNameFk = Name.NameId " +
209 209
					" LEFT OUTER JOIN Name AS AcceptedName ON RelPTaxon.PTNameFk2 = AcceptedName.NameId " +
210
				" WHERE (PTaxon.StatusFk IN (2,3,4)) AND (RelPTaxon.RelQualifierFk NOT IN (2, 4, 5, 6, 7)) ";
210
				" WHERE (PTaxon.StatusFk IN (2,3,4)) AND (RelPTaxon.RelQualifierFk NOT IN (2, 4, 5, 6, 7, 101, 102, 103, 104, -99)) ";
211 211
			
212 212
			if (StringUtils.isNotBlank(config.getRelTaxaIdQuery())){
213 213
				strQuery += String.format(" AND (RelPTaxon.RelPTaxonId IN " +

Also available in: Unified diff