2.10.2.6.8. Entity Type Expressions
An entity type expression can be used to restrict query polymorphism.
The TYPE operator returns the exact type of the argument.
The syntax of an entity type expression is as follows:
-
entity_type_expression ::= type_discriminator | entity_type_literal | input_parameter
-
type_discriminator ::= TYPE(identification_variable | single_valued_object_path_expression | input_parameter )
An entity_type_literal is designated by the entity name.
The Java class of the entity is used as an input parameter to specify the entity type.
Examples:
SELECT e
FROM Employee e
WHERE TYPE(e) IN (Exempt, Contractor)
SELECT e
FROM Employee e
WHERE TYPE(e) IN (:empType1, :empType2)
SELECT e
FROM Employee e
WHERE TYPE(e) IN :empTypes
SELECT TYPE(e)
FROM Employee e
WHERE TYPE(e) Exempt