如何访问多选条件元组查询中的联接列？

ajsxfq5m 于 2021-06-25 发布在 Mysql

关注(0)|答案(1)|浏览(415)

表类：

private static final long serialVersionUID = 1L;
@Audited(targetAuditMode = RelationTargetAuditMode.NOT_AUDITED)
@JoinColumn(name = "SUBSYSTEM_ID", referencedColumnName = "ID")
@ManyToOne
private Subsystem subsystem;

@Transient
private Long subsystemId;

查询条件：

public PagedSearchResult<Tuple> findByUserId1(Long id, UserSubsystemSearchCriteria searchCriteria) {
        final CriteriaBuilder criteriaBuilder = getEntityManager().getCriteriaBuilder();
        final CriteriaQuery<Tuple> query = criteriaBuilder.createTupleQuery();
        final Root<UserSubsystem> from = query.from(UserSubsystem.class);
        query.multiselect(from.get("subsystemId"));
        query.groupBy(from.get("subsystemId"));

如果我删除连接并暂时重写列定义，它就可以工作，但我需要那个连接。

Java mysql many-to-one hibernate-criteria CriteriaQuery

来源：https://stackoverflow.com/questions/48216529/how-can-i-access-to-joined-column-in-multiselect-criteria-tuple-query

1条答案

按热度按时间

weylhg0b1#

不知道你想实现什么，但最简单的解决方案

@Entity
class UserSubsystem {

    private static final long serialVersionUID = 1L;

    @Id
    private Long id;

    @JoinColumn(name = "SUBSYSTEM_ID", referencedColumnName = "ID")
    @ManyToOne
    private Subsystem subsystem;

    @Column(name = "SUBSYSTEM_ID", updatable = false, insertable = false)
    private Long subsystemId;

}

和查询

CriteriaBuilder criteriaBuilder = getEntityManager().getCriteriaBuilder();
CriteriaQuery<UserSubsystem> query = criteriaBuilder.createQuery(UserSubsystem.class);
Root<UserSubsystem> from = query.from(UserSubsystem.class);
from.fetch("subsystem", JoinType.LEFT);
query.groupBy(from.get("subsystemId"));
entityManager.createQuery(query);

赞(0）回复(0）举报 2021-06-25

我来回答

如何访问多选条件元组查询中的联接列？

1条答案

相关问题

热门标签

最新问答