<style>
/* Changing the layout to use less space for mobiles */
@media screen and (max-device-width: 480px), screen and (-webkit-min-device-pixel-ratio: 2) {
#email-body { min-width: 30em !important; }
#email-page { padding: 8px !important; }
#email-banner { padding: 8px 8px 0 8px !important; }
#email-avatar { margin: 1px 8px 8px 0 !important; padding: 0 !important; }
#email-fields { padding: 0 8px 8px 8px !important; }
#email-gutter { width: 0 !important; }
}
</style>
<div id="email-body">
<table id="email-wrap" align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#f0f0f0;color:#000000;width:100%;">
<tr valign="top">
<td id="email-page" style="padding:16px !important;">
<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#ffffff;border:1px solid #bbbbbb;color:#000000;width:100%;">
<tr valign="top">
<td bgcolor="#3e4c4e" style="background-color:#3e4c4e;color:#ffffff;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;line-height:1;"><img src="https://www.jboss.org/dms/hibernate/images/jira/jiraheader_hibernate.png" alt="" style="vertical-align:top;" /></td>
</tr><tr valign="top">
<td id="email-banner" style="padding:32px 32px 0 32px;">
<table align="left" border="0" cellpadding="0" cellspacing="0" width="100%" style="width:100%;">
<tr valign="top">
<td style="color:#505050;font-family:Arial,FreeSans,Helvetica,sans-serif;padding:0;">
<img id="email-avatar" src="https://hibernate.onjira.com/secure/useravatar?avatarId=10162" alt="" height="48" width="48" border="0" align="left" style="padding:0;margin: 0 16px 16px 0;" />
<div id="email-action" style="padding: 0 0 8px 0;font-size:12px;line-height:18px;">
<a class="user-hover" rel="harpreet" id="email_harpreet" href="https://hibernate.onjira.com/secure/ViewProfile.jspa?name=harpreet" style="color:#6c797f;">Harpreet Singh</a>
commented on <img src="https://hibernate.onjira.com/images/icons/improvement.gif" height="16" width="16" border="0" align="absmiddle" alt="Improvement"> <a style='color:#6c797f;text-decoration:none;' href='https://hibernate.onjira.com/browse/HHH-6353'>HHH-6353</a>
</div>
<div id="email-summary" style="font-size:16px;line-height:20px;padding:2px 0 16px 0;">
<a style='color:#6c797f;text-decoration:none;' href='https://hibernate.onjira.com/browse/HHH-6353'><strong>DetachedCriteria: get sql alias used for sql projection or sql restriction</strong></a>
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr valign="top">
<td id="email-fields" style="padding:0 32px 32px 32px;">
<table border="0" cellpadding="0" cellspacing="0" style="padding:0;text-align:left;width:100%;" width="100%">
<tr valign="top">
<td id="email-gutter" style="width:64px;white-space:nowrap;"></td>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr valign="top">
<td colspan="2" style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 16px 0;width:100%;">
<div class="comment-block" style="background-color:#edf5ff;border:1px solid #dddddd;color:#000000;padding:12px;"><p>I have created one class to resolve this issue. This class is reflection of SQLProjection. The whole functionality is same as<br/>
that of SQLProjection except that it provides one additional functionality.<br/>
According to current scenario we can only replace the root alias with its SQL equivalent alias but with this you can provide<br/>
the alias which you want to replace with the SQL alias and its necessary to provide both alias name and criteria both together.</p>
<p>public class MySQLProjection implements Projection {</p>
<p> /** The Constant serialVersionUID. */<br/>
private static final long serialVersionUID = 1L;</p>
<p> /** The sql query string to retrieve columns. */<br/>
private final String sql;</p>
<p> /** The sql string to specify group by query. */<br/>
private final String groupBy;</p>
<p> /** The types of the columns retrieved in sql query. */<br/>
private final Type[] types;</p>
<p> /** The aliases of the columns retrieved in sql query. */<br/>
private String[] aliases;</p>
<p> /** The aliases of the columns retrieved in sql query. */<br/>
private String[] columnAliases;</p>
<p> /** True if group by property is there means it is sql group projection. */<br/>
private boolean grouped;</p>
<p> /**</p>
<ul>
<li>The set of aliases to be replaced with their SQL aliases. Here set must</li>
<li>contain values as POJOAlias.property from which we get sql alias for</li>
<li>POJOAlias. One POJOAlias with one dot operator and property is must.<br/>
*/<br/>
private Set<String> aliasSetToReplace;</li>
</ul>
<p> @Override<br/>
public String toSqlString(final Criteria criteria, final int loc,<br/>
final CriteriaQuery criteriaQuery) throws HibernateException {
return replaceAliasWithSQLAlias(sql, criteria, criteriaQuery);
}</p>
<p> @Override<br/>
public String toGroupSqlString(final Criteria criteria, final CriteriaQuery criteriaQuery)<br/>
throws HibernateException {
return replaceAliasWithSQLAlias(groupBy, criteria, criteriaQuery);
}</p>
<p> /**</p>
<ul>
<li>Replace alias in the given query string with their sql aliases from</li>
<li>criteria query.</li>
<li></li>
<li>@param queryString</li>
<li>the query string</li>
<li>@param criteria</li>
<li>the criteria</li>
<li>@param criteriaQuery</li>
<li>the criteria query</li>
<li>@return the string<br/>
*/<br/>
private String replaceAliasWithSQLAlias(final String queryString, final Criteria criteria,<br/>
final CriteriaQuery criteriaQuery) {<br/>
String sqlString = StringHelper.replace(queryString, "{alias}",<br/>
criteriaQuery.getSQLAlias(criteria));</li>
</ul>
<p> Iterator<String> iterator = aliasSetToReplace.iterator();<br/>
String aliasPropString;<br/>
String aliasString;<br/>
int index;<br/>
while (iterator.hasNext()) {<br/>
aliasPropString = iterator.next();<br/>
index = aliasPropString.indexOf('.');<br/>
if (index > 0) {<br/>
aliasString = aliasPropString.substring(0, index);<br/>
sqlString = StringHelper.replace(sqlString, "{" + aliasString + "}",<br/>
criteriaQuery.getSQLAlias(criteria, aliasPropString));<br/>
}<br/>
}</p>
<p> return sqlString;<br/>
}</p>
<p> @Override<br/>
public Type[] getTypes(final Criteria crit, final CriteriaQuery criteriaQuery)<br/>
throws HibernateException {
return types;
}</p>
<p> @Override<br/>
public String toString() {
return sql;
}</p>
<p> /**</p>
<ul>
<li>Instantiates a new my sql projection.</li>
<li></li>
<li>@param sqlQuery</li>
<li>the sql</li>
<li>@param columnAliasArray</li>
<li>the column aliases</li>
<li>@param typeArray</li>
<li>the types<br/>
*/<br/>
public MySQLProjection(final String sqlQuery, final String[] columnAliasArray,<br/>
final Type[] typeArray) {
this(sqlQuery, null, columnAliasArray, typeArray);
}</li>
</ul>
<p> /**</p>
<ul>
<li>Instantiates a new my sql projection.</li>
<li></li>
<li>@param sqlQuery</li>
<li>the sql</li>
<li>@param groupBySQL</li>
<li>the group by</li>
<li>@param columnAliasArray</li>
<li>the column aliases</li>
<li>@param typeArray</li>
<li>the types<br/>
*/<br/>
public MySQLProjection(final String sqlQuery, final String groupBySQL,<br/>
final String[] columnAliasArray, final Type[] typeArray) {
this(sqlQuery, groupBySQL, columnAliasArray, typeArray, null);
}</li>
</ul>
<p> /**</p>
<ul>
<li>Instantiates a new my sql projection.</li>
<li></li>
<li>@param sqlQuery</li>
<li>the sql</li>
<li>@param groupBySQL</li>
<li>the group by</li>
<li>@param columnAliasArray</li>
<li>the column aliases</li>
<li>@param typeArray</li>
<li>the types</li>
<li>@param aliasSet</li>
<li>the aliases map to replace<br/>
*/<br/>
public MySQLProjection(final String sqlQuery, final String groupBySQL,<br/>
final String[] columnAliasArray, final Type[] typeArray,<br/>
final Set<String> aliasSet) <div class="error"><span class="error">Unknown macro: { this.sql = sqlQuery; this.types = typeArray; this.aliases = columnAliasArray; this.columnAliases = columnAliasArray; this.grouped = groupBySQL != null; this.groupBy = groupBySQL; if (aliasSet == null) {
this.aliasSetToReplace = new HashSet<String>();
} else {
this.aliasSetToReplace = aliasSet;
} }</span> </div></li>
</ul>
<p> @Override<br/>
public String[] getAliases() {
return aliases;
}</p>
<p> @Override<br/>
public String[] getColumnAliases(final int loc) {
return columnAliases;
}</p>
<p> @Override<br/>
public boolean isGrouped() {
return grouped;
}</p>
<p> @Override<br/>
public Type[] getTypes(final String alias, final Criteria crit,<br/>
final CriteriaQuery criteriaQuery) {
return null; // unsupported
}<br/>
<br/>
@Override<br/>
public String[] getColumnAliases(final String alias, final int loc) {
return null; // unsupported
} }<br/>
}</p></div>
<div style="color:#505050;padding:4px 0 0 0;"> </div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td><!-- End #email-page -->
</tr>
<tr valign="top">
<td style="color:#505050;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:10px;line-height:14px;padding: 0 16px 16px 16px;text-align:center;">
This message is automatically generated by JIRA.<br />
If you think it was sent incorrectly, please contact your <a style='color:#6c797f;' href='https://hibernate.onjira.com/secure/ContactAdministrators!default.jspa'>JIRA administrators</a>.<br />
For more information on JIRA, see: <a style='color:#6c797f;' href='http://www.atlassian.com/software/jira'>http://www.atlassian.com/software/jira</a>
</td>
</tr>
</table><!-- End #email-wrap -->
</div><!-- End #email-body -->