mysql - hql:内部加入 Map 并在选择中访问键和值？

Question

问题来了

    public class Company
    {
            private Map<Location, Manager> locationManagerMap;
    } 

一个地点只有一个经理。一个经理可以关联到多个位置。

    public class Assignment
    {
            private Location location;
            private Manager
    } 

现在假设我想通过使用 hql 查询和子查询来检索公司的所有分配列表，如下所示。

    String query = "select from Assignment as assignment where (assignment.location, assignment.manager) in (select locationManager._____________ from Company as company inner join  company.locationManagerMap as locationManager where company.id=?) "

在上面查询的子查询中，company 与 locationManagerMap 是内联的。我想访问此映射的键和值以执行多列条件检查。请建议查询中空白的语法应该是什么？

Answer 1

应该是这样的:

... index(locationManager), locationManager ...