Hi all, this seems somehow related to a recent post asking about "querying for foreign key". Here as well, I guess, tables have to be joined, but I don't see how to pack this into a single ORDERBY clause.
The main table is Entry, which owns _status = ForeignKey( "Status"). Status owns a field 'value' besides some other fields. Now I would like the Entry rows I select by some other criterion (e.g. their priority) be ordered by the value field of the Status of the Entry. When I ORDERBY Status.q._value then SQLOBJECT correctly tells me, that Entry doesn't own a _value field. All other combinations don't work neither. This has to be done more SQL-ish, right? Anyone willing to help me out here? Cheers Paul ------------------------------------------------------------------------------ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
