Index: ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/action/TousseInstanceAction.java =================================================================== diff -u -r17082 -r17275 --- ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/action/TousseInstanceAction.java (.../TousseInstanceAction.java) (revision 17082) +++ ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/action/TousseInstanceAction.java (.../TousseInstanceAction.java) (revision 17275) @@ -1189,8 +1189,9 @@ + dateQueryAdapter.dateAdapter(now); } - sql += " and po.departmentStock_id is not null " - + " group by po.locationForDisplay,po.location"; +// sql += " and po.departmentStock_id is not null " +// + " group by po.locationForDisplay,po.location"; + sql += " group by po.locationForDisplay,po.location"; ResultSet result = objectDao.executeSql(sql); List list = new ArrayList();