Index: ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/dwr/table/SterilizationRecordTableManager.java =================================================================== diff -u -r34671 -r34730 --- ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/dwr/table/SterilizationRecordTableManager.java (.../SterilizationRecordTableManager.java) (revision 34671) +++ ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/dwr/table/SterilizationRecordTableManager.java (.../SterilizationRecordTableManager.java) (revision 34730) @@ -168,7 +168,7 @@ String sql = "select h.id,h.optionText from "+ Sterilisation.class.getSimpleName() + " s join "+ HttpOption.class.getSimpleName() +" h on h.optionText=s.sterilizationPurpose " - + "where h.optionListId='sterilizationPurpose' and s.sterilisation='"+ name +"'"; + + "where h.optionListId='"+ HttpOption.SYSTEMSETTING_STERILIZATIONPURPOSE +"' and s.sterilisation='"+ name +"'"; ResultSet rs = null; try { rs = objectDao.executeSql(sql);