其中employer.employees.gender =“m”，或者如何过滤项目字段上的项目列表？ [英] where employer.employees.gender = 'm', or how to filter a list of Items on a field of Item?

问题描述

雇主有很多员工（一对多的关系）。下面是我如何为给定：雇主选择员工：
$ b

 选择employer.employees 
从雇主雇主
雇主=：雇主
  

我想过滤结果，只得到 gender 字段为 m 的雇员。我怎样才能实现这个使用HQL？在 doc中是否有任何我没有注意到的条款

理想情况下，类似于：
$ b

 和employer.employees.gender ='m'
  

或

  and each（employer.employees）.gender ='m'
  
 
 
解决方案
 >  SELECT ey.name 
 FROM雇主雇主
 LEFT JOIN employer.employees ey 
 WHERE ey.gender ='m'AND雇主=：雇主
  
希望这有助于您。
 


An employer has many employees (a one-to-many relationship). Here is how I select the employees for a given :employer:
select employer.employees
from Employer employer
where employer = :employer
I would like to filter the results to get only the employees which gender field is m. How could I achieve this using HQL? Is there any clause that I haven't noticed in the doc?

Ideally, something like:
and employer.employees.gender = 'm'
Or:
and each(employer.employees).gender = 'm'

解决方案
Try this query 
SELECT ey.name
FROM Employer employer
LEFT JOIN employer.employees ey
WHERE ey.gender = 'm' AND employer = :employer
Hope this helps.

                        
这篇关于其中employer.employees.gender =“m”，或者如何过滤项目字段上的项目列表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！