Query from multiples domains in grails
Revision 2
I have issues. Please help me I you can.
I have 3 domains called:
- DomainA(id, propA1,propA2)
- DomainB(id, propB1,propB2,forgeinKeyToDomainA)
- DomainC(id, propC1,propC2,forgeinKeyToDomainB)
The relationship of domains is:
DomainA hasMany DomainB, DomainB beLongsTo DomainA
DomainB hasMany DomainC, DomainC beLongsTo DomainB
I wants to get all record from DomainC that propA1="value1"
Imaging SQL code:
Select DomainC.*
from DomainA,DomainB,DomainC
where DomainA.id=DomainB.forgeinKeyToDomainA
and DomainB.id=DomainC.forgeinKeyToDomainB
and DomainA.propA1="value1"
I can executing SQL code in grails, but I wants to use Hibernate.
Thanks.
Posted 26-Apr-13 16:20pm
by
ngnlx.