withCriteria "or" like by property of other table

Question

I have this:

results = Quotation.withCriteria {
    resultTransformer(CriteriaSpecification.ALIAS_TO_ENTITY_MAP)
            createAlias("client","cte")
            createAlias("client.assessor","asr")
        or{
            ilike("asr.name", "%${params.find}%") 
            ilike("cte.name", "%${params.find}%")
        }
        projections {   
             groupProperty "id","id"
             groupProperty "cte.name", "client"
             groupProperty "asr.name", "employee"
        }
} 

but return empty, I think it's by associations (client and client.assessor), I need to search by customer name or assessor name but this is a property from other table/obj.

Answer 1

Change your createAlias to

def results = Quotation.withCriteria {
    resultTransformer CriteriaSpecification.ALIAS_TO_ENTITY_MAP
    createAlias "client","cte"
    createAlias "cte.assessor","asr" /* <--- HERE ^^ */

    or {
        ilike "asr.name", "%${params.find}%" 
        ilike "cte.name", "%${params.find}%"
    }
    projections {   
         groupProperty "id","id"
         groupProperty "cte.name", "client"
         groupProperty "asr.name", "employee"
    }
}