Red Hat Summit이 콘텐츠는 선택한 언어로 제공되지 않습니다.
14.10. The Where Clause
The
where clause allows you to refine the list of instances returned. If no alias exists, you can refer to properties by name:
from Cat where name='Fritz'
from Cat where name='Fritz'
If there is an alias, use a qualified property name:
from Cat as cat where cat.name='Fritz'
from Cat as cat where cat.name='Fritz'
This returns instances of
Cat named 'Fritz'.
The following query:
select foo from Foo foo, Bar bar where foo.startDate = bar.date
select foo
from Foo foo, Bar bar
where foo.startDate = bar.date
returns all instances of
Foo with an instance of bar with a date property equal to the startDate property of the Foo. Compound path expressions make the where clause extremely powerful. Consider the following:
from Cat cat where cat.mate.name is not null
from Cat cat where cat.mate.name is not null
This query translates to an SQL query with a table (inner) join. For example:
from Foo foo where foo.bar.baz.customer.address.city is not null
from Foo foo
where foo.bar.baz.customer.address.city is not null
would result in a query that would require four table joins in SQL.
The
= operator can be used to compare not only properties, but also instances:
from Cat cat, Cat rival where cat.mate = rival.mate
from Cat cat, Cat rival where cat.mate = rival.mateselect cat, mate from Cat cat, Cat mate where cat.mate = mate
select cat, mate
from Cat cat, Cat mate
where cat.mate = mate
The special property (lowercase)
id can be used to reference the unique identifier of an object.
from Cat as cat where cat.id = 123 from Cat as cat where cat.mate.id = 69
from Cat as cat where cat.id = 123
from Cat as cat where cat.mate.id = 69
The second query is efficient and does not require a table join.
Properties of composite identifiers can also be used. Consider the following example where
Person has composite identifiers consisting of country and medicareNumber:
from bank.Person person
where person.id.country = 'AU'
and person.id.medicareNumber = 123456
from bank.Person person
where person.id.country = 'AU'
and person.id.medicareNumber = 123456from bank.Account account
where account.owner.id.country = 'AU'
and account.owner.id.medicareNumber = 123456
from bank.Account account
where account.owner.id.country = 'AU'
and account.owner.id.medicareNumber = 123456
Once again, the second query does not require a table join.
Refer to the "Referring to Identifier Property" section for more information regarding referencing identifier properties)
The special property
class accesses the discriminator value of an instance in the case of polymorphic persistence. A Java class name embedded in the where clause will be translated to its discriminator value.
from Cat cat where cat.class = DomesticCat
from Cat cat where cat.class = DomesticCat
You can also use components or composite user types, or properties of said component types.
An "any" type has the special properties
id and class that allows you to express a join in the following way (where AuditLog.item is a property mapped with <any>):
from AuditLog log, Payment payment where log.item.class = 'Payment' and log.item.id = payment.id
from AuditLog log, Payment payment
where log.item.class = 'Payment' and log.item.id = payment.id
The
log.item.class and payment.class would refer to the values of completely different database columns in the above query.
'%20d='M201.5%20305.5c-13.8%200-24.9-11.1-24.9-24.6%200-13.8%2011.1-24.9%2024.9-24.9%2013.6%200%2024.6%2011.1%2024.6%2024.9%200%2013.6-11.1%2024.6-24.6%2024.6zM504%20256c0%20137-111%20248-248%20248S8%20393%208%20256%20119%208%20256%208s248%20111%20248%20248zm-132.3-41.2c-9.4%200-17.7%203.9-23.8%2010-22.4-15.5-52.6-25.5-86.1-26.6l17.4-78.3%2055.4%2012.5c0%2013.6%2011.1%2024.6%2024.6%2024.6%2013.8%200%2024.9-11.3%2024.9-24.9s-11.1-24.9-24.9-24.9c-9.7%200-18%205.8-22.1%2013.8l-61.2-13.6c-3-.8-6.1%201.4-6.9%204.4l-19.1%2086.4c-33.2%201.4-63.1%2011.3-85.5%2026.8-6.1-6.4-14.7-10.2-24.1-10.2-34.9%200-46.3%2046.9-14.4%2062.8-1.1%205-1.7%2010.2-1.7%2015.5%200%2052.6%2059.2%2095.2%20132%2095.2%2073.1%200%20132.3-42.6%20132.3-95.2%200-5.3-.6-10.8-1.9-15.8%2031.3-16%2019.8-62.5-14.9-62.5zM302.8%20331c-18.2%2018.2-76.1%2017.9-93.6%200-2.2-2.2-6.1-2.2-8.3%200-2.5%202.5-2.5%206.4%200%208.6%2022.8%2022.8%2087.3%2022.8%20110.2%200%202.5-2.2%202.5-6.1%200-8.6-2.2-2.2-6.1-2.2-8.3%200zm7.7-75c-13.6%200-24.6%2011.1-24.6%2024.9%200%2013.6%2011.1%2024.6%2024.6%2024.6%2013.8%200%2024.9-11.1%2024.9-24.6%200-13.8-11-24.9-24.9-24.9z'/%3e%3c/svg%3e){kind=small}