Hi,

I have defination as following (sample only). I could not figure out how to search the order using the StatusName as search expression :

<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="Order, AppLib" table="Order">

<id name="ID" column="ID">
<generator class="identity" />
</id>

<property name="CreateBy"></property>
<property name="CreateDate"></property>
<property name="UpdateBy"></property>
<property name="UpdateDate"></property>
<property name="TS" insert="false" update="false"/>

<many-to-one name="Status" class="Status, AppLib" column="StatusID"/>

</class>

<class name="Status, AppLib" table="Status">

<id name="StatusID" column="StatusID">
<generator class="identity" />
</id>

<property name="StatusName"></property>

</class>
</hibernate-mapping>

Regards,

Boon Seong

haven't debugged the code but this is a starting point.

-devon

devonl, thanks for your reply.

How do I do a sorting based on StatusName then ? I tried to add the Order.Asc to the subcriteria(status) but it return error saying that subcriteria cannot be sorted. My code as following :

ICriteria statusCriteria = session.CreateCriteria(typeof(Order))
.CreateCriteria("Status"));

statusCriteria.AddOrder(Order.Asc("StatusName"));

yes, that is a limitation of the ICriteria interface currently. if you need to sort on the StatusName, then you will have to use HQL or an embedded SQL query.

-devon

hmmm, i saw this in another thread:


i wonder if you could do something like:


or something similar. if you try it, can you please report back to the board?

nope... the method does not work

okay, then you are relegated to HQL i'm afraid.

-devon