[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-6353) DetachedCriteria: get sql alias used for sql projection or sql restriction

[Matthieu Maquevice (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=44263#comment-44263 ] 

Matthieu Maquevice commented on HHH-6353:
-----------------------------------------

The method is also needed for the Criteria class.

> 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira