eladmin icon indicating copy to clipboard operation
eladmin copied to clipboard

ManyToMany查询,同时使用join和IN进行查询,将会产生重复数据

Open rdyfriends opened this issue 2 years ago • 0 comments

ManyToMany查询,同时使用join和IN进行查询,将会产生重复数据

@Query(propName = "id", joinName = "users", type = Query.Type.IN)
private Set<Long> userIds;


@ManyToMany(fetch = FetchType.EAGER)
@ApiModelProperty(value = "责任人")
@JoinTable(name = "t_gz_plan_user",
        joinColumns = {@JoinColumn(name = "plan_id", referencedColumnName = "id")},
        inverseJoinColumns = {@JoinColumn(name = "user_id", referencedColumnName = "user_id")})
private Set<User> users;

rdyfriends avatar Jun 16 '22 16:06 rdyfriends