DetachedCriteria: get sql alias used for sql projection or sql restriction -------------------------------------------------------------------------- Key: HHH-6353 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6353 Project: Hibernate Core Issue Type: Improvement Components: query-criteria Environment: Java 6, Jboss 5.1.0, Hibernate 3 Reporter: Dave A method to get sql alias is needed from DetachedCriteria in order to use non-root entity alias in sql restriction or sql projection. DetachedCriteria: String getSqlAlias(String alias) // alias has been created detachedCriteria.createAlias("group","g"); String sqlAlias = detachedCriteria.getSqlAlias("g"); detachedCriteria.add(Restrictions.sqlRestriction(sqlAlias + ".name='John'")); detachedCriteria.setProjection(Restrictions.sqlProjection(sqlAlias + ".name")); -- 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