Title:
Bug 84960:(Watson Migration Closure)I have a component with a property that links to a CFC
| View in TrackerStatus/Resolution/Reason: Closed/Won't Fix/
Reporter/Name(from Bugbase): marc esher / marc esher (marcesher)
Created: 11/09/2010
Components: ORM Support
Versions: 9.0.1
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:
I have a component with a property that links to a CFC. This will result in an array of those components. The Component for that property in addition has another linked component.I'd like to be able to order that array on properties of that component.For example:Activity has an array of ActivitySpecies (this links to a join table)ActivitySpecies has a Species Species has a "CommonName" propertyI'd like to do this in Activity:property name="activitySpecies" fieldtype="one-to-many" cfc="ActivitySpecies" fkcolumn="ActivityID" inverse="true" cascade="all-delete-orphan" orderby="species.CommonName";
Method:
Result:
Invalid column name XXXX when using orderby on property
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3042693
External Customer Info:
External Company:
External Customer Name: marc esher
External Customer Email: 70390EBF47F01CAF992015B9
External Test Config: 11/09/2010Attachments:
Comments: