Grails: use domain method in named query

Question

Hi,

in my domain model, I have a method that does something with my data.

e.g.

class Person {

    String lastname
    String firstname

    String bigname() {
        return lastname.toUpperCase()
    }

    static namedQueries = {
        withBigname { name ->
            eq(this.bigname(), name)
        }
    }
}

I want to use this method like a property in the named query, but

this.bigname()

only throws a

java.lang.IncompatibleClassChangeError

-Exception.

Does anyone know how to use domain methods in criteria and named queries?

---

Update: I now tried this:

class Person {

    String lastname
    String firstname
    String bigname

    static transients = [ 'bigname' ]

    def getBigname() {
        return lastname.toUpperCase()
    }

    static namedQueries = {
        withBigname { name ->
            eq('bigname', name)
        }
    }
}

But it only results in a "could not resolve property: bigname"-exception...

Answer 1

Try to name the method in JavaBean getter and setter notation. Rename method bigname() to getBigname().

Answer 2

On a static closure, you don't have a this. You'll either need to store the bigname in the Database, do some sort of case insensitive criteria.

Answer 3

looks like you are trying to accomplish this:

class Person {

  String lastname
  String firstname

  static namedQueries = {
      withName { name ->
          eq('lastname', name, [ignoreCase: true])
      }
  }
}