I have a datagrid that has check boxes to filter the "statuses" of orders the administration wishes to see.

The statuses 1 - pending, 2 - shipped, 3 - cancelled and 4 - shipped.

The Order object and mapping correctly loads a Order object and OrderState object (which is in another table)

When I try and do a Expression based criteria I create a int array of each status I want to be in the "set" and then I call the criteria method

for example

int[] states = new int {1.4};

IList Orders = session.CreateCriteria(typeof(Order)).Add(Expression.In("Status.OrderStatusId", states )).List();

Order.Status.OrderStatusId will match one of those integers, however when I run the query I get the following exception :

{"unresolved property: Status.OrderStatusId []" } System.Exception

The class Order has a member called Status of type OrderStatus which has a Name and orderStatusId , for some reason the Expression is being evaluated as if I was inferrring orderStatusId was an array which it isn't and I wasn't trying to either :)


What am I doing wrong ?

Thanks
Grant

It can't parse through properties of properties. Only "Status" would be valid in an ICriteria.

You can to use hql to do what you're wanting to do.

Mike

Thanks mike, I'll take a look at HQL.

I ended up fixing this using HQL and the "in" keyword and posted the solution to my blog

http://theresidentalien.typepad.com/ginormous/2005/05/using_a_in_set_.html