java - 游戏框架中的订单相关实体

Question

假设我在 play 框架中有两个实体类，java:

@Entity
public class User extends Model implements Validation {
    @Id
    private String email;
    private String password;
    @OneToOne
    @PrimaryKeyJoinColumn(referencedColumnName = "userEmail")
    private Address address;}

和

@Entity
public class Address extends Model{
    @Id
    @Column(name="userEmail")
    private String email;
    private String streetName;
    private String city;
    private String country;}

现在我想从数据库中检索所有用户并根据地址模型的 streetName 属性对它们进行排序。我用过这个List<Restaurant> list = Restaurant.find.order("streetName asc").findList();

但我收到以下错误:

[PersistenceException: Query threw SQLException:Unknown column 'streetName' in 'order clause' 
Bind values:[] 

如果我将任何 User 属性作为订单字符串 ( ...order("email asc").findList(); )，它会起作用并且我会得到有序列表，但如何才能使其根据 Address 属性对用户进行排序？

Answer 1

尝试 Restaurant.find.order("address.streetName asc").findList()