query查询的jion问题

return (root, query, cb) -> {

Predicate

p1=cb.equal(root.jion(“departmentStoreHouse”).get(“id”).as(Long.class),departmentId);

Predicate p2=cb.equal(root.get(“batchNumber”).as(String.class),batchNumber);

Predicate p3=cb.equal(root.get(“expirationTime”).as(Date.class),expirationTime);

Predicate

p4=cb.equal(root.get(“status”).as(Integer.class),ConsumablesInventory.STATUS_TWOIN);

//query.orderBy(cb.desc(root.get(“expirationTime”).as(Date.class)));

query.where(cb.and(p1,p2,p3,p4));

query.distinct(true);

return query.getRestriction();

};