I think you have to manually map the fk/pk as an attribute. then cayenne knows the field for ordering. when reverse engineering a database cayenne does not create attribute mappings for pks and fks.
Michael Lepine <[EMAIL PROTECTED]> wrote: In my application, I have a few queries that I've created with the SelectQuery class. In some instances, I'd like to order the results by the primary or foreign keys in the table using the addOrdering() method. I have not found a way to do this. I believe I get an error that the column does not exist in the ObjEntity instance referenced by the SelectQuery object. Maybe I'm approaching this the wrong way. Is there a way to add an "order by" clause to a query that includes a primary or foreign key? Thanks for your time and any help. - Mike ___ sent via WebmailLight 3.1.11
