与And结合使用或使用CriteriaBuilder和谓词

Question

我们有一个现有的谓词来从表中获取数据，我们还需要将此条件添加到该查询中

AND (SERVICE_ID IN (1,2,34,5) or (SERVICE_ID IN (83,24) and DEST_WALLET_TYPE=4 and DEST_ENTITY_TYPE = 6))

我们尝试了不同的方法，但我们所能做到的就是

and (SERVICE_ID in (1,2,34,5) 
or DEST_WALLET_TYPE_ID=4 and DEST_ENTITY_TYPE=6 and (SERVICE_ID in (24 , 83)))

简单括号应在<代码>或 之后开始，并应在最终条件之后结束。

我们试过这些

步骤-1

Predicate p1 = builder.and(root.get("serviceId").in(params.getFinancialServiceList()));
                
Predicate p22 = builder.equal(root.get("destWalletType"), (params.getMainWallet()));
Predicate p23 = builder.equal(root.get("destEntity"), params.getBillerEntity());
Predicate p2 = builder.and(p22, p23, builder.and(root.get("serviceId").in(Services.TOPUP, Services.DATA_RECHARGE)));
                
builder.or(p1, p2);

步骤-2

Predicate p1 = builder.and(root.get("serviceId").in(params.getFinancialServiceList()));
                
builder.or(p1, 
            builder.and(builder.equal(root.get("destWalletType"), (params.getMainWallet()))),
            builder.and(builder.equal(root.get("destEntity"), params.getBillerEntity())),
            builder.and(builder.and(root.get("serviceId").in(Services.TOPUP, Services.DATA_RECHARGE))));

我们能得到一些帮助吗？

Answer 1

使用此选项：

Predicate p1 = root.get("serviceId").in(params.getFinancialServiceList());
Predicate p21 = root.get("serviceId").in(Services.TOPUP, Services.DATA_RECHARGE);
Predicate p22 = builder.equal(root.get("destWalletType"), (params.getMainWallet()));
Predicate p23 = builder.equal(root.get("destEntity"), params.getBillerEntity());

Predicate p2 = builder.and(p21, p22, p23);
builder.or(p1, p2);