grails - Unknown column ‘x.y’ in ‘where clause’ when using sqlRestriction with createAlias

Question

i have a withCriteria with createAlias("xRecords", "x", CriteriaSpecification.LEFT_JOIN)

When i try to do sqlRestriction("x.y > 1") I get the error:

Unknown column ‘x.y’ in ‘where clause’

y is a column in xRecords.

What am i missing?

question from:https://stackoverflow.com/questions/65851538/unknown-column-x-y-in-where-clause-when-using-sqlrestriction-with-createalia

Answer 1

Waitting for answers