If expression support in the criteria API ----------------------------------------- Key: HHH-3316 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3316 Project: Hibernate3 Issue Type: Improvement Components: query-criteria Environment: Hibernate 3, MySQL 4.1 Reporter: Avlesh Singh Priority: Minor MySQL supports IF() as one of the Control Flow Structures. I am not too sure if other dialects support an equivalent. This is how it works - SELECT IF(1>2,2,3); -> 3 To the best of my knowledge, there is no implementation in the Restrictions/Expression class for this control structure. Underneath is what I am talking about this implementation in the Expression class public static org.hibernate.criterion.Criterion ifExpression(org.hibernate.criterion.Criterion criterion, java.lang.Object trueValue, java.lang.Object falseValue){} for which usage would typically look like this- Criteria queryCriteria = session.createCriteria(MyBean.class); queryCriteria.add(Expression.ifExpression(Expression.isNull("myProperty"), "myProperty", new Date())); the bean definition is underneath - class MyBean{ private Date myProperty; } I would love to hear from others on this. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira