我有一个奇怪的问题,我需要连接一个视图(工作台)与一个表(FA_TICKET),以建立这个连接,我使用的运算符与子选择.一切顺利..。但是..。当我尝试向它添加一个新的过滤器时,它不会解决。
Subquery<Workbench> subFr = query.subquery(Workbench.class);
Root<FrTicket> rootFrTicket = subFr.from(FrTicket.class);
subFr.select(rootFrTicket.get("ticketId"));
Predicate pred = root.get("ticketNum").in(subFr);
criteriaBuilder.and(pred, criteriaBuilder.equal(root.get("type"), TicketType.FR_TICKET));
predicates.add(pred);
....
//predicates is defined at begining and have other filters
return criteriaBuilder.and(predicates.toArray(new Predicate[0]));当我看到子查询部分时,应该是这样的:
select .... from Workbench where ... and (ticketNum in (SUBSELECT) and type = ?)但是..。关于票证类型的行从未被解析过,我看到:
select .... from Workbench where ... and (ticketNum in (SUBSELECT))如果在定义and时更改顺序,则会看到以下内容:
Predicate pred = criteriaBuilder.equal(root.get("type"), TicketType.FR_TICKET);
criteriaBuilder.and(pred, root.get("ticketNum").in(subFr));
select .... from Workbench where ... and (type = ?)我怎样才能将这种类型包含在同一组中?因为我需要用其他类型的票证实体来建立一个过滤器,有一个不同的类型。
谢谢
发布于 2022-02-04 13:47:35
类似于枚举的问题,它们在CriteriaBuilder类中存在问题。
所以,如果我做这个改变:
Subquery<Workbench> subFr = query.subquery(Workbench.class);
Root<FrTicket> rootFrTicket = subFr.from(FrTicket.class);
subFr.select(rootFrTicket.get("ticketId"));
Predicate pred = root.get("ticketNum").in(subFr);
criteriaBuilder.and(pred, criteriaBuilder.equal(root.get("type").as(String.class), TicketType.FR_TICKET).name());
predicates.add(pred);
....
//predicates is defined at begining and have other filters
return criteriaBuilder.and(predicates.toArray(new Predicate[0]));效果很好。
https://stackoverflow.com/questions/70985717
复制相似问题