Expression.Or() Help!!

swtechno · **Joined:** Thu Jun 01, 2006 11:27 am **Posts:** 28

I'm trying to do the following filter

criteria = session.CreateCriteria(typeof(Form));

//Criteria1:filter category in form
criteria.CreateCriteria("Category")
.Add(Expression.Like("Code", categoryCode));

//Criteria2:filter category in line form
criteria.CreateCriteria("LineList")
.CreateCriteria("Category")
.Add(Expression.Like("Code", categoryCode));

I want to do an OR between Criteria1 and Criteria2, something like that

criteria.Add(Expression.Or(
criteria.CreateCriteria("Category")
.Add(Expression.Like("Code", categoryCode)),
criteria.CreateCriteria("LineList")
.CreateCriteria("Category")
.Add(Expression.Like("Code", categoryCode))
))

Any suggestion??
Thanks

denis.etienne · **Posted:** Tue Aug 22, 2006 4:10 pm

if what you mean by

Code:

 //Criteria2:filter category in line form
criteria.CreateCriteria("LineList")
.CreateCriteria("Category")
.Add(Expression.Like("Code", categoryCode)); 

is linelist.category.code like '%aCode%'

Code:

c = criteria.CreateCriteria("LineList")
c.createAlias("category","categ")
c.Add(Expression.Like("categ.code", categoryCode)); 

would be more realistic
and you can use Disjunction for the OR

like in

Code:

List cats = sess.createCriteria(Cat.class)
    .add( Restrictions.in( "name", new String[] { "Fritz", "Izi", "Pk" } ) )
    .add( Restrictions.disjunction()
        .add( Restrictions.isNull("age") )
        .add( Restrictions.eq("age", new Integer(0) ) )
        .add( Restrictions.eq("age", new Integer(1) ) )
        .add( Restrictions.eq("age", new Integer(2) ) )
    ) )
    .list();