Index: ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/action/RecyclingRecordAction.java =================================================================== diff -u -r33362 -r33368 --- ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/action/RecyclingRecordAction.java (.../RecyclingRecordAction.java) (revision 33362) +++ ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/action/RecyclingRecordAction.java (.../RecyclingRecordAction.java) (revision 33368) @@ -2732,7 +2732,7 @@ + "join OrgUnitGroup oug on oug.id=oog.orgGroupId "; selectUnitGroupNameSql = "min(oug.name) orgUnitGroupName,"; } - if(CollectionUtils.isEmpty(departGroupIds) && StringUtils.isNotBlank(recyDepartmentGroupIdsSql)){ + if(CollectionUtils.isNotEmpty(departGroupIds) && StringUtils.isNotBlank(recyDepartmentGroupIdsSql)){ extraSql += " and (" + SqlUtils.getNonStringFieldInLargeCollectionsPredicate("oug.id", departGroupIds) + " or 1=1 " + recyDepartmentGroupIdsSql + ") "; }else if(StringUtils.isNotBlank(recyDepartmentGroupIdsSql)){ extraSql += recyDepartmentGroupIdsSql;