Advertisement
naimul64

LEFT join By Criteria

Dec 19th, 2017
227
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Groovy 0.44 KB | None | 0 0
  1. class A{
  2.     B someObject
  3. }
  4.  
  5. class B{
  6.     C importantObject
  7. }
  8.  
  9. class C{
  10.     boolean interestingFlag
  11. }
  12.  
  13. ####
  14. # LEFT JOIN
  15. ###
  16.  
  17. def result = A.withCriteria{
  18.         createAlias('someObject', 'so', CriteriaSpecification.LEFT_JOIN)
  19.         createAlias('so.importantObject', 'imp', CriteriaSpecification.LEFT_JOIN)
  20.         or {
  21.             isNull('so.importantObject')
  22.             eq('imp.interestingFlag', false)
  23.         }
  24.  
  25.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement