How to compare to fields using ==, <=, >= , > , < operators

[GoogleCodeExporter]

NOTE: If you have a question rather than a bug report or feature request,
please post at http://groups.google.com/group/java-generic-dao .

What steps will reproduce the problem?
1.If we want to compare to columns from same table or different table not able 
to add those conditions 
2.
3.

What is the expected output? What do you see instead?
It should compare

What version of the product are you using? On what operating system?


Please provide any additional information below.

Original issue reported on code.google.com by abhijitb...@gmail.com on 28 Nov 2013 at 2:45

[GoogleCodeExporter]

Please post your question to http://groups.google.com/group/java-generic-dao.

Original comment by dwolvert on 29 Nov 2013 at 9:13

• Changed state: Invalid
• Removed labels: Type-Defect

[GoogleCodeExporter]

Hi dwolvert ,
         Please explain why it is invalid defect, I already check with org.hibernate.criterion.Restrictions class , we can use Restrictions -> eqProperty (p1,p2) compares two columns of table. at least this functionality should be there.  

Original comment by abhijitb...@gmail.com on 30 Nov 2013 at 4:53

[GoogleCodeExporter]

abhijitbanke,

Hi. Sorry. The reason is because the framework actually does have this feature. 
If you post to the group then others who have the same question will be able to 
see the answer.

Here's how it's done:

search.addFilterCustom("{p1} < {p2}");

see 
http://hibernate-generic-dao.googlecode.com/svn/trunk/docs/api/com/googlecode/ge
nericdao/search/Filter.html#custom%28java.lang.String%29

That said, we really do have a "defect" in our documentation, because this 
custom filter feature has not been added to the documentation on the 
wiki--which is a major flaw.

Original comment by dwolvert on 30 Nov 2013 at 6:01