Hi all,

I am facing a different problem now. The fields in my search operation are not mandatory. The user will enter the sort criteria and the order of sorting.
In the below code companyName and companyType belong to Company POJO and city and countryCode belong to CompanyAddress POJO. Now Search is successful only when I choose atleast one values from both of the POJO and fails otherwise. The sort order is also entered by the user. How can I decide the sort order based on the users choice? The search has to be made even with a value from a single POJO?


SessionFactory sessionFactory = new Configuration().configure()
.buildSessionFactory();
session = sessionFactory.openSession();

List crit = session.createCriteria(Company.class).add(Restrictions.or(Restrictions.like("searchName",compname),Restrictions.like("companyType", companyType)))
.addOrder(Order.asc(sortCriteria))
.createCriteria("addresses", "address")
.add(Restrictions.or(Restrictions.like("address.city",city),Restrictions.like("address.countryCode",ctry )))
.list();
session.close();
System.out.println("Results----->"+crit.size());
return crit;


Where I am wrong here?. How could we change the default and operation to an or operation?

With Regards,
Amutha[/code]

Well in this case you cannot hardcode it in the first place beacuse you never know what the user may want to filter on . I had a similar case which i coded in the following way . This code may help u out.
It may not run this is just for an explantion.

public List findByCriteria(List<Criterion> criterion, List<Criterion> innerCriteria) {

// criterion contains the list of all restrictions

Criteria crit = currentSession().createCriteria(Company.class);
Criteria crit2 = null;

for (Criterion c : criterion) {
crit.add(c);

}




for (Criterion c : inner) {
crit2.add(c);
}


crit = crit2;

}


return crit.list();
}

Well in this case you cannot hardcode it in the first place beacuse you never know what the user may want to filter on . I had a similar case which i coded in the following way . This code may help u out.
It may not run this is just for an explantion.

public List findByCriteria(List<Criterion> criterion, List<Criterion> innerCriteria) {

// criterion contains the list of all restrictions

Criteria crit = currentSession().createCriteria(Company.class);
Criteria crit2 = null;

for (Criterion c : criterion) {
crit.add(c);

}


if (innerCriteria != null)
{

crit2 = crit.createCriteria("address");
for (Criterion c : inner) {
crit2.add(c);
}

crit = crit2;


}


return crit.list();
}


Similarly u may accept the list on which u would like to order and add it to the criteria .

Hi gurpreet,

Thanks for your immediate response. We are not sure about the users filter options. My criteria fields are not mandatory. The user may select any options.

Why do we require the List to be passed to the below method


public List findByCriteria(List<Criterion> criterion, List<Criterion> innerCriteria) {
}

In my case I have Company Pojo associated with CompanyAddress. Any idea to go with this?


With thanks,
Amutha[/code]