Title:
Bug 85248:There are many times when I need to use HQL or other statements and use filters
| View in TrackerStatus/Resolution/Reason: Closed/Won't Fix/
Reporter/Name(from Bugbase): Eric Twilegar / Eric Twilegar (twillerror)
Created: 11/30/2010
Components: ORM Support
Versions: 9.0
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 /
Priority/Frequency: Minor / Very few users will encounter
Locale/System: English / Platforms All
Vote Count: 0
Problem:
There are many times when I need to use HQL or other statements and use filters. Without them I'm running into many issues.If I call getSomeOneToMany() accessor I need a way to filter these.Also, I need a way to that with HQL so that I can pregrab one to many records with a filter applied.For instance imagine you had a table called TextByLanguage which held a valud per each language.For now I can call getTextByLanaguage() on my object and loop and find the "Englinsh" record and use it.However, what I really want at the end of the day is an HQL query (hopefully inside cfquery tag ) where I can say Pre fetch language and filter by englinsh.I can use the where on the mapping because the lnaguage is a dynamic property.I could create a static mapping for each language...but that would be hard and in more real world cases the dynamic attribute isn't so predicatable.
Method:
Result:
Need good filter support.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3042896
External Customer Info:
External Company:
External Customer Name: Eric Twilegar
External Customer Email: 3D9A02F5446CCE0A992015D5
External Test Config: 11/30/2010Attachments:
Comments: