grails - Grails-findAll连接两个表

Question

我是Grails的新手。我从数据库检索数据时遇到问题。我有带类的域名，类似...

class Lightbox {    
   String name = ''
   String link  = ''
   static hasMany = [users: LightboxUserAccount]
}

class LightboxUserAccount {
   UserAccount userAccount
   static belongsTo = [lightbox: Lightbox]  
}

class UserAccount {
   String username
   ...
}

我想列出ID = 4的用户拥有的所有“灯箱”。我在尝试

def my_lb = Lightbox.findAll("from Lightbox as lb where lb.users=:userAccount", [userAccount: springSecurityService.getCurrentUser()])

要么

def my_lb = Lightbox.findAllByUsers(4)

这些都不适合我。我究竟做错了什么？谢谢

Answer 1

试试这个:

Lightbox.findAll("from Lightbox as lb where :userAccount in (lb.users)", [userAccount: springSecurityService.getCurrentUser()])