Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedatamanager/urgent/service/UrgentLevelManagerImpl.java =================================================================== diff -u -r36084 -r36106 --- ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedatamanager/urgent/service/UrgentLevelManagerImpl.java (.../UrgentLevelManagerImpl.java) (revision 36084) +++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedatamanager/urgent/service/UrgentLevelManagerImpl.java (.../UrgentLevelManagerImpl.java) (revision 36106) @@ -273,7 +273,7 @@ sql.append(TousseDefinition.class.getSimpleName()); sql.append(" titd on tit.tousseDefinition_id=titd.id join "); sql.append(UrgentAdditionalInfo.class.getSimpleName()); - sql.append(" ua on ua.id=tit.urgentAdditionalInfo_Id left join ss_users su on su.id=ua.urgentContactId left join "); + sql.append(" ua on ua.id=tit.urgentAdditionalInfoId left join ss_users su on su.id=ua.urgentContactId left join "); sql.append(OperationRoom.class.getSimpleName()); sql.append(" rm on rm.id=ua.urgentOperationRoomId where titd.ancestorID=td.ancestorID and ti.id="); if(DatabaseUtil.isPoIdValid(recyclingItemId)){ @@ -316,7 +316,7 @@ sbf.append(TousseInstance.class.getSimpleName()); sbf.append(" ti on ti.id=ii.lastTousseInstanceId join "); sbf.append(UrgentAdditionalInfo.class.getSimpleName()); - sbf.append(" ua on ua.id=ti.urgentAdditionalInfo_Id where "); + sbf.append(" ua on ua.id=ti.urgentAdditionalInfoId where "); sbf.append(SqlUtils.getStringFieldInLargeCollectionsPredicate("bd.barcode", iDCardInstanceBarcodes)); ResultSet rs = null; Map urgentAdditionalInfoMap = new HashMap();