Index: ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/action/RecyclingRecordAction.java =================================================================== diff -u -r33378 -r33386 --- ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/action/RecyclingRecordAction.java (.../RecyclingRecordAction.java) (revision 33378) +++ ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/action/RecyclingRecordAction.java (.../RecyclingRecordAction.java) (revision 33386) @@ -2711,7 +2711,7 @@ String includeTousseIdsSql = CollectionUtils.isEmpty(includeTousseIds)?"": " and " + SqlUtils.getNonStringFieldInLargeCollectionsPredicate("td.ancestorID", includeTousseIds); String joinRecyclingRecordSql = ""; String joinInvoicePlanSql = ""; - String departGroupIdsSql = ""; + String departGroupIdsSql = " and 1=0 "; if(StringUtils.isNotBlank(extraSql) && extraSql.contains("orgUnitCoding") || CollectionUtils.isNotEmpty(departGroupIds)){ joinRecyclingRecordSql = "join OrgUnit ou on ou.orgUnitCoding=po.departCode "; joinInvoicePlanSql = "join OrgUnit ou on ou.orgUnitCoding=po.departCoding ";