Message Title

周雁鸣 created an issue

Issue Type:	Improvement
Affects Versions:	5.2.12
Assignee:	Vlad Mihalcea
Components:	hibernate-core
Created:	08/Feb/2018 16:51 PM
Priority:	Major
Reporter:	周雁鸣

http://docs.jboss.org/hibernate/orm/5.2/userguide/html_single/Hibernate_User_Guide.html#criteria-narrowing

 
                                                                List cats = sess.createCriteria(Cat.class)
    .add( Restrictions.sqlRestriction("lower({alias}.name) like lower(?)", "Fritz%", Hibernate.STRING) )
    .list();

The

{alias} placeholder will be replaced by the row alias of the queried entity.

@Formula("balance/(select sum(a.balance) from customer a where a.gender={alias}

.gender)")
private BigDecimal percentage;

here

{alias}

not resolved by row alias.

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira