hi robert,
the orderby should be used in the sql when retrieving this children. if you want to modify the orderby you could use a query-customizer.
hth jakob
Robert S. Sfeir schrieb:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Yes, that gives it a default, but there is no way to change that based on query as far as I can tell, I wanted to make sure I didn't miss anything.
R
On Feb 6, 2005, at 3:58 AM, Jakob Braeuchi wrote:
hi robert,
have you tried the orderby in collection-descriptor ?
jakob
Robert S. Sfeir schrieb:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Either I'm rusty or this is a little trickier to do...
The issue is that I have a TicketType, which has a Collection of Attribute which itself has a Collection of AttributeType.
When I do a select for a Collection of Attribute(s) for a TicketType (select * from ticket_types tt, attributes a where ticket_type=1 and tt.type_id = a.type_id order by a.attribute_order) I get a TicketType with its Attribute Collection and the Attribute Collection is correctly sorted by the order column. But I need to take this a step further because an Attribute has a Collection of AttributeValue(s), and I want those AttributeValue objects to also be sorted by a specific column.
In other words I need the 3rd IN query that OJB triggers to get the AttributeValue to be sorted...
What's the most efficient way to do this? I'd rather not do 2 selects myself, I like having one select and have OJB deal with the prefetched relationships... and sorting...
I have another example which goes deeper from project to tickettype etc...
Thanks
R
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)
iD8DBQFCBVhrJhqny0eCHK8RAvnjAJ0ZxKTArcUkJyxQlBZJ36JuEWOg5wCfXiCP
56Ietiiuhj5oIMVgHTFepT8=
=WJoc
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (Darwin)
iD8DBQFCBhojJhqny0eCHK8RAsD7AJ9FW2OovX5gPaljRPfBY2QhVab4oQCghHlA wDpEg4gAbx99IF0qJVzUuec= =8LLJ -----END PGP SIGNATURE-----
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
