Grails

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.2 final
• Fix Version/s: 1.2.1, 1.3-M1
• Component/s: Persistence
• Labels:

  None

The following named query results in SQL with no WHERE clause:

class MyDomain implements Serializable {
  String userId 
  String reportsTo
  String positionNum

  static mapping = {
    table 'some_legacy_table'
    version false
    cache usage: 'read-only'
    userId column: 'USER_OPRID'
    reportsTo column: 'REPORTS_TO'
    positionNum	column: 'POSITION_NBR'
    id composite:['userId', 'reportsTo', 'positionNum']
  }

  static namedQueries = {
    userAccessList { user, manager, position ->
      and {
        eq( 'userId', user )
        or {
          eq 'reportsTo', manager
          eq 'positionNum', position
        }
      }
    }
  }
}

• Assignee:

  Jeff Brown

  Reporter:

  Jeff Brown

• Created:

  24/Jan/10 9:19 AM

  Updated:

  24/Jan/10 3:58 PM

  Resolved:

  24/Jan/10 3:58 PM