HQL help needed: order by item in map

[Michal]

Hi,

I have the following mapping of my "Industry" object:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="Domain.Industry, Core" table="industry">

<id name="ID" unsaved-value="0">
<generator class="identity" />
</id>

<map name="AllNames"
access="nosetter.camelcase-underscore"
table="_dict_industry_name"
cascade="all-delete-orphan">
<key column="record_id"></key>
<index column="culture_id" type="Int32"></index>
<element column="translation" type="String"></element>
</map>

</class>
</hibernate-mapping>

Now I would like to query all Industries ordered by the element of a
given culture_id.
I am stuck here ... I think i am close with this, but it does not
work:

string query = "from Industry industry order by industry.AllNames
[:lcid]";
IQuery q = NHibernateSession.CreateQuery(query);
q.SetParameter("lcid", DomainCulture.Current);

Thanks guys!

[abrakadabr]

from Industry industry
where index(industry) = :lcid
order by industry.AllNames

[abrakadabr]

from Industry industry
where index(industry.AllNames) = :lcid

order by industry.AllNames

On 15 май, 06:03, Michal <mga...@gmail.com> wrote:

> Hi,
>
> I have the following mapping of my "Industry" object:
>
> <?xml version="1.0" encoding="utf-8" ?>
> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
>   <class name="Domain.Industry, Core" table="industry">
>
>     <id name="ID" unsaved-value="0">
>       <generator class="identity" />
>     </id>
>
>     <map name="AllNames"
>       access="nosetter.camelcase-underscore"
>       table="_dict_industry_name"
>       cascade="all-delete-orphan">
>       <key column="record_id"></key>
>       <index column="culture_id" type="Int32"></index>
>       <element column="translation" type="String"></element>
>     </map>
>
>   </class>
> </hibernate-mapping>
>

> Now I would like toqueryall Industries ordered by the element of a

> given culture_id.
> I am stuck here ... I think i am close with this, but it does not
> work:
>

> stringquery= "from Industry industryorderby industry.AllNames

[Michal]

Thanks a lot abrakadabr. It looked promising but i am getting this
error

illegal syntax near collection: index [from
ITAssessments.Core.Domain.Industry industry where index
(industry.AllNames) = :lcid order by industry.AllNames]

do you have a clue?

[Michal]

I have tried just ordering by the index ( from Industry industry order
by index(industry.AllNames) ) and it throws the same error:

illegal syntax near collection: index [from

ITAssessments.Core.Domain.Industry industry order by index
(industry.AllNames)]

On May 15, 5:17 pm, abrakadabr <kov...@gmail.com> wrote:

[Michal]

I have tried just ordering by the index ( from Industry industry order
by index(industry.AllNames) ) and it throws the same error:

illegal syntax near collection: index [from
ITAssessments.Core.Domain.Industry industry order by index
(industry.AllNames)]

On May 15, 5:17 pm, abrakadabr <kov...@gmail.com> wrote: