2008/10/29 Bart Reyserhove <[EMAIL PROTECTED]>
> Is there no way of doing this using the Criteria api? I am using the
> MultiCriteria here, and as far as I know I don't have the possibility to use
> HQL there?
In MultiCriteria no but in MultiQuery yes... even if MultiQuery, IMO, need
some deep refactoring.
>
>
> On Wed, Oct 29, 2008 at 12:32 PM, Fabio Maulo <[EMAIL PROTECTED]>wrote:
>
>> from Company c join c.Address a where a.City like 'bru%' order by
>> c.CompanyGroup.Name
>>
>> 2008/10/29 Bart Reyserhove <[EMAIL PROTECTED]>
>>
>>> Yeah I know that is the easy part, what I am trying to do is something
>>> along the lines of:
>>>
>>> DetachedCriteria.For<Company>()
>>> .CreateCriteria("Address").Add(Restrictions.Like("City","bru")
>>> .CreateCriteria("CompanyGroup","cg").AddOrder(Order.Asc("cg.Name")
>>>
>>> The problem is of course that CompanyGroup is an association of Company
>>> and not of Address.
>>>
>>>
>>> On Wed, Oct 29, 2008 at 4:56 AM, Ayende Rahien <[EMAIL PROTECTED]>wrote:
>>>
>>>> Something like:
>>>> DetachedCriteria.For<Company>()
>>>> .CreateCriteria("CompanyGroup", "cg")
>>>> .AddOrer(Order.Asc("cg.Name")
>>>>
>>>>
>>>> On Wed, Oct 29, 2008 at 12:21 AM, Bart Reyserhove <
>>>> [EMAIL PROTECTED]> wrote:
>>>>
>>>>> I have an domain object: Company.
>>>>> 1) Company has an association with an Address
>>>>> 2) Company also has an association with CompanyGroup
>>>>>
>>>>> I am trying to use the ICriteria stuff to create a query that retrieves
>>>>> all Companies where Address.Country = 'Belgium' and I want to order this
>>>>> result on the name property of CompanyGroup.
>>>>>
>>>>> The filter is no problem at all. I can easily find all Belgian
>>>>> companies, but sorting them on another association seems really difficult
>>>>> at
>>>>> first sight.
>>>>>
>>>>> How can I approach this?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Bart
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>> --
>> 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
-~----------~----~----~----~------~----~------~--~---
