Grails - OperatorNamesInDynamicMetho...

The following operator names can be used within the respective dynamic methods names (countBy, findBy, findAllBy*)
  • LessThan
  • LessThanEquals
  • GreaterThan
  • GreaterThanEquals
  • Between
  • Like
  • Ilike (i.e. ignorecase like)
  • IsNotNull
  • IsNull
  • Not
  • Equal
  • NotEqual
  • And
  • Or (can sometimes be problematic as of 0.5-snap)
The above operator names can be considered keywords, i.e. you will run into problems when querying domain classes that have one of these names used as property names.