Hello!

Let's say I've got an HQL query that's looking something like this:




Well, unfortunately that doesn't work the way I want, because it of course returns 't.field1' results that _do_not_ equal "something", so long as 't.bar', 't.bar2', etc equal one of those specified values.

I want to ensure that the results returned from the query only produce records where 't.field1' == 'something' BUT where one or more of those OR's are also satisfied.

Using sql, I'd use an except clause, something like:



How would I achieve equivalent results using HQL?

Many thanks!

Do you want field one to be equal to something or not equal to something ?
You have = to operator for field1 in the HQL you posted ...

from MyTable t where
t.field1 = 'something' and
t.bar = 'blah' or
t.bar2 = 'blah2' or
t.field3 = 'that'

I assume it was a typo. Have you tried this :

from MyTable t where
t.field1 != 'something' and
(t.bar = 'blah' or
t.bar2 = 'blah2' or
t.field3 = 'that' )

I have added brackets for expression priority...

Oh, yes - that's because I was using the EXCEPT clause, so using that, I was specifying to exclude all records that were not equal to 'something'.





Ah sheesh - it was as easy as using brackets! I should have known to have tried that...

Thank you very much for helping me out there!

Cheers