snimavat opened a new issue, #14623:
URL: https://github.com/apache/grails-core/issues/14623

   What i am trying to achieve is almost similar to what discussed here 
http://grails.1312388.n4.nabble.com/Subqueries-in-criteria-tp1678501p3078371.html
 -- 
   
   Given the domain classes
   
   ```
   Book {
      Author author
      Date datePublished
   }
   
   Author {
      Date dob
   }
   
   ```
   I would like to find all authors who has published book in 2016 (using 
criteria and exists)
   
   So i would expect some thing like this to work
   
   ```
   Author.withCriteria {
     exists(Book.where({
       datePublished = xxx
      eqProperty("author.id", "this.id") //here i am trying to access the root 
criteria alias using this.
   }).id())
   }
   ```
    
   However this doesnt give the expected result, and generated sql query looks 
wrong.
   
   What is expected:
   A way to refer to root criteria alias, when doing subqueries
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to