Grails ORM Join

[Sudhakar Vaddi]

Hi,

I have two domain objects Person and Address.

Person hasmany addresses.

I need join these two using Criteria Builder. Below is the SQL :

select * from Person p, Address a where p.address_id = a.id and p.id=?

How to convert this into Criteria in Grails?

Appreciate your help.

Thanks
Sudhakar

[uday]

These blogs may help you

http://www.intelligrape.com/blog/2010/06/14/grails-createcriteria-query-example/#comments
http://adhockery.blogspot.com/2009/06/querying-by-association-redux.html


On Jun 18, 12:44 pm, Sudhakar Vaddi <vaddi.sudha...@googlemail.com>
wrote:

[karthi]

If you want to query person for given address.id, the following is the code

Person.createCriteria().list{
       address{
              eq("id",some_address_id)
        }
}

else if you want all person with corresponding addresss

Person.list()

the above should suffice, its object orientation.

On Fri, Jun 18, 2010 at 2:44 PM, uday <meuday...@gmail.com> wrote:

These blogs may help you

http://www.intelligrape.com/blog/2010/06/14/grails-createcriteria-query-example/#comments
http://adhockery.blogspot.com/2009/06/querying-by-association-redux.html

On Jun 18, 12:44 pm, Sudhakar Vaddi <vaddi.sudha...@googl{email.com>