Gents, quick question: I have a fairly simple query withCriteria() but I keep getting empty results. class Version { LocatableIndex data // nullable } class LocatableIndex { LocatableIndexVersioning versioning } class LocatableIndexVersioning { Date validUntil } That's my model (simplified) then I do: Version.withCriteria { or { isNull('data') and { isNotNull('data') data { versioning { gt('validUntil', date_version_at_time) } } } } } Even if I have Version's with null data, I keep receiving null results while I expect those to be part of the result because of the OR isNull('data')

Just a heads-up—there are folks here who aren’t “gents,” so you might want to go with a more inclusive greeting if you’re hoping for help from everyone. 🙂

Sorry, I dont even know what that means...

Sorry, I should have been clearer “Gents” in English is a group of men, there are also women and potentially people who use a different gender here.

Sorry, didn't know that word could offend someone, I use it formally/jokingly in forums for years and nobody was offended by it.

Not offensive at all if everyone is a male, but as an example most of our software dev team is female. In silicon valley and in many startups there tend to be a lot of “bros” or “techbros” that are sometimes not very considerate and talk down to women. So I try to be as inclusive as possible.

Ok might be a cultural thing, I never had any complaints when I worked in an office with other people.