Replace Criteria with Search (a.k.a. implement search using HQL instead of Criteria)

[GoogleCodeExporter]

I originally used Criteria because they are easier to manipulate after we
have used the search to create them initially. But we're getting to the
point where our search covers almost every aspect that Criteria can cover.
Additionally, the Criteria we create end up with so many esoteric aliases
in them anyway, they are not of much use to the user.

In the generic-dao Google Code project implementation, they have their own
criteria object and use it to generate eql/hql. I think hql might be the
more native choice than Criteria. I think it would be simpler to translate
directly from our search object to hql anyway because there are a lot of
difficulties converting to Criteria.

Original issue reported on code.google.com by dwolvert on 26 Aug 2008 at 3:55

[GoogleCodeExporter]

The new HQL implementation is complete with as much functionality as the old 
Criteria 
implementation had.

The new implementation is actually simpler and, with a little bit of luck, 
extendable 
to EQL query language for projects that don't use hibernate.

Original comment by dwolvert on 28 Oct 2008 at 5:57

• Changed title: Replace Criteria with Search (a.k.a. implement search using HQL instead of Criteria)
• Changed state: Verified