Can I check real type of object in HQL Where clause?

sergunok · **Posted:** Wed Aug 31, 2005 10:22 am

Need something like:
"WHERE Person Is Manager"

or even

"WHERE IF Person Is Manager THEN (Person as Manager).Salary > 1000 ELSE 1=1 END"

Does HQL allow that?

KPixel · **Posted:** Wed Aug 31, 2005 12:09 pm

Try

Code:

from Manager Person where Person.Salary > 1000

sergunok · **Posted:** Wed Aug 31, 2005 12:48 pm

Thank you!

The problem is that I have two classes
Person and Manager. Person is the base class.

I need select all objects of class Person.
If the object is actually of class Manager I
wont additionaly check in the query that it's Salary is less then 1000
("Salary" is property of class Manager)

tinomen · **Joined:** Tue May 24, 2005 12:55 pm **Posts:** 56

Please post the maps for these 2 classes. HQL relies on the mapping. Assuming you are subclassing these in your mapping you will have to put the property that holds your discriminator-value in the WHERE clause. (where obj.property = discrminator_value_wanted

KPixel · **Posted:** Fri Sep 02, 2005 6:34 am

AFAIK, you will have to issue two queries:

Code:

from Manager m where m.Salary > 1000

and

Code:

from Person p where p.Discrimitator <> ManagerDisc

(replace p.Discrimitator by the name of your discriminator and ManagerDisc by the discriminator value of the class Manager)