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