Sorry, that's not quite what I meant. My example wasn't very clear. Let's assume the class Photos.PhotoClass has a property called "location" indicating where the photo was taken. I'd like to be able to sort by that "location" property.
You can try
#set ($sql = ", BaseObject as obj, DBStringListProperty as prop join prop.list list where obj.name=doc.fullName and obj.className='Photos.PhotoClass' and obj.name<>'Photos.PhotoClassTemplate' and obj.id=prop.id.id and prop.id.name='category' and list='${category}' order by doc.creationDate") or #set ($sql = ", BaseObject as obj, DBStringListProperty as prop join prop.list list where obj.name=doc.fullName and obj.className='Photos.PhotoClass' and obj.name<>'Photos.PhotoClassTemplate' and obj.id=prop.id.id and prop.id.name='category' and list='${category}' order by doc.date")
depending if you want to sort by the creation date or update date of the documents
-- "Any sufficiently advanced technology is indistinguishable from magic." -- Arthur C. Clarke -- Brian D. Switzer email: herkamur [at] canada [dot] com web: http://bswitzer.railfan.net/