Index: ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/action/RecyclingRecordAction.java =================================================================== diff -u -r35638 -r35648 --- ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/action/RecyclingRecordAction.java (.../RecyclingRecordAction.java) (revision 35638) +++ ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/action/RecyclingRecordAction.java (.../RecyclingRecordAction.java) (revision 35648) @@ -2907,7 +2907,7 @@ String includeTousseIdsSql = CollectionUtils.isEmpty(includeTousseIds)?"": " and " + SqlUtils.getNonStringFieldInLargeCollectionsPredicate("td.ancestorID", includeTousseIds); String joinRecyclingRecordSql = ""; String joinInvoicePlanSql = ""; - String departGroupIdsSql = " and 1=0 "; + String departGroupIdsSql = " and 1=1 "; 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 ";