Friday, 15 February 2013

hibernate - Grails combining "in" and "isEmpty" inside and OR ignores "isEmpty" -


I want to be able to write a criterion that allows me to search all the clues which will be given to a specific development outfit (Hammony)

My domain model looks like this:

  leads {set < Development & gt; If I search for a particular list based on the list of development, then I can use the following within my criteria:  
  
  developmentsOfInterest {'in' ("Id", developments * .id)}  

I'm using this to find all people without any development

  empty ("Interest of development")  

So the argument tells me that if I add these two in one or two or I get the combined list ..

< Pre> or {is empty ("development notifications") in development translation {'in'} ("id", development * .id)}}

it is not .. this is the only interest list

SQL Generated is as follows

where (this_.account_id =? And (do not exist) choose Lead_development 1 from where it_. Id = lead_developments_of_interest_id) or (in developmen1_.id (?,?))))

but I think this would be the right SQL command ? It reads correctly:

(does not exist (choose from lead_development 1, where it_. Id = lead_developments_of_interest_id) or (in developmen1_.id (?,?))

Update: I add a whole bunch of additional query code with the addition of SEL (blank), or the size adds eq (), and by adding "by" and "in". I am feeling that it is wrong, that can not work because (it will only show the items which are available in VIC

  where (this_.account_id =? And (? = (Count count (*) Lead_development where this_.id = lead_developments_of_interest_id) or this_.id in (?) ) Lower order (this_1_.first_name) asc limit?  

Account_id part of the filter criteria.

You can put your criteria in this way:

  or {sizeEq 'developmental information', 0 'in" interest of development ", development}  

No comments:

Post a Comment