params.max = Math.min(params.max ? params.int('max') : 20, 100)
if (!params.sort) params.sort = "lastUpdated"
if (!params.order) params.order = "desc"
if (!params.offset) params.offset = 0
def user = session.user
def query= "from Project p where exists ( from Member m where p.id = m.project.id and m.user.login='"+user.login+"') order by p." +params.sort+ " " +params.order+ "";
            
def projectList  = Project.findAll(query,[max:params.max?.toInteger(), offset:params.offset?.toInteger()])
            
def projectTotalCount = Project.findAll(query).size()
           
[projectInstanceList: projectList, projectInstanceTotal: projectTotalCount]

Select all projects where the current user is  a member. 
A project has a set of members where each member is comprised of user and role.

Grails : Select all projects where the current user is  a member.

query

Groovy