Index: forgon-tools/src/main/java/com/forgon/tools/util/SqlUtils.java =================================================================== diff -u -r22975 -r23786 --- forgon-tools/src/main/java/com/forgon/tools/util/SqlUtils.java (.../SqlUtils.java) (revision 22975) +++ forgon-tools/src/main/java/com/forgon/tools/util/SqlUtils.java (.../SqlUtils.java) (revision 23786) @@ -103,7 +103,7 @@ String itemSql = getStringFieldInCollectionsPredicate(field,item); itemSqls.add(String.format("(%s)",itemSql)); } - return String.join(" or ", itemSqls); + return String.format(" (%s) ",String.join(" or ", itemSqls)); } return " 1=0 "; @@ -124,7 +124,7 @@ String itemSql = getNonStringFieldInCollectionsPredicate(field,item); itemSqls.add(String.format("(%s)",itemSql)); } - return String.join(" or ", itemSqls); + return String.format(" (%s) ",String.join(" or ", itemSqls)); } return " 1=0 "; }