13 Dec
2005
13 Dec
'05
11:10 p.m.
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/