Hello,

I would like to ask how (and if it is possible) to use Criteria API to create a query, which would have OR condition that either something matches in the (left) joined table or something matches in the base table.

Example: I want to get all persons which have status 'Active' or belong to some group.

Pseudo code:

ICriteria crit = session.CreateCriteria(typeof(Person));

crit.CreateCriteria("PersonGroup",JoinType.OuterLeftJoin);

crit.Add(Expression.Or(Expression.Eq("Status","Active")
Expression.Eq("PersonGroup","Some Group"))));

^ This is an error as the criteria API does not know to which table the condition belongs to.

Any help appreciated

Makli

You should use the CreateCriteria morphism that allows an alias to be set. You can then use thusly defined aliases to disambiguate your properties.

It isn't altogether clear that you need to use CreateCriteria() for the PersonGroup... you might be able to get away with CreateAlias(). I don't know if it actually less expensive, but it doesn't create a new ICriteria instance.

marcal, thanks for the reply.

I can create alias but the expression (Expression.Eq for example) takes parameter "propertyName". So am I supposed to pass alias and property name together? Like string 'TableAlias.PropertyName'? Or is the syntax different?

Thank you