I don't know how look your domain... perhaps removing the "left" would be enough
2009/9/6 Martin Nilsson <[email protected]> > If I added a reference to Product from LocalizedProduct then it works with > this hql (added "or lp.Product is null": > > "select distinct p from Product p left join fetch p.LocalizedProducts lp > where lp.CultureInfoName = :pSomeCulture or lp.Product is null" > > Thanks again Fabio for pointing me to the right direction! > > > On Sun, Sep 6, 2009 at 4:06 PM, Martin Nilsson <[email protected]>wrote: > >> Thanks Fabio. >> >> But do I get products that have no matching pSomeCulture (like the Truck >> product example below)? I tried this but didn't get that product. >> >> >> >> On Sun, Sep 6, 2009 at 3:43 PM, Fabio Maulo <[email protected]> wrote: >> >>> select distinct p from Product p left join fetch p.LocalizedProducts lp >>> where lp.CultureInfoName = :pSomeCulture >>> >>> 2009/9/6 Martin Nilsson <[email protected]> >>> >>> My domain model >>>> >>>> class Product >>>> prop Title : string >>>> prop LocalizedProducts : IList(of LocalizedProduct) >>>> >>>> class LocalizedProduct >>>> prop CultureInfoName : string >>>> prop Title : string >>>> >>>> Can anyone help me to create a query that selects the products and the >>>> localized product (if exists). >>>> >>>> So if I have this data: >>>> >>>> Product table >>>> id Title >>>> 1 Car >>>> 2 Truck >>>> >>>> LocalizedProduct table >>>> id Title CultureInfoName Product_id >>>> 14 Bil sv-SE 1 >>>> 15 Auto de-DE 1 >>>> >>>> >>>> Then I should have these instances (note that "de-DE" is not loaded): >>>> >>>> Car >>>> Id : 1 >>>> Title : Car >>>> LocalizedProducts : { LocalizedProd { Id : 14, Title : Bil } } >>>> >>>> Truck >>>> Id : 2 >>>> Title : Truck >>>> LocalizedProducts : {} >>>> >>>> Any help is appreciated! >>>> >>>> >>>> >>> >>> >>> -- >>> Fabio Maulo >>> >>> >>> >> > > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
