[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2952) Support for referencing non-root entities in Criteria SQL expressions

Support for referencing non-root entities in Criteria SQL expressions --------------------------------------------------------------------- Key: HHH-2952 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2952 Project: Hibernate Core Issue Type: Improvement Components: query-criteria Affects Versions: 3.2.2 Environment: Java 5, MySQL 5.0, Eclipse 3.2 Reporter: Jacob Gyllenstierna Assignee: Diego Plentz Attachments: RestrictionsExt.java, SQLAliasedCriterion.java, SQLAliasedCriterion.java, SQLAliasedCriterion.java, SQLAliasedProjection.java It would be very helpful to be able to reference non-root entities in Criteria SQL restrictions and projections using placeholders similar to {alias}. A very simple but uninteresting example: criteria.createAlias("group", "g"); criteria.add(Restrictions.sqlRestriction("{g}.id=:groupId"));