Hi Erin,
Thanks for the reply. Unfortunately the query didn't work for me. Please
see my doubts in another thread "Sorting by property of a class".
(By mistake I posted two queries)
Thanks
Roopesh
You have the .id.id matching happening a little
inconsistently. I've seen
this work:
, BaseObject as obj,
StringProperty as prop,
StringProperty as otherprop
where
(obj.name=doc.fullName and obj.className='Users.UserClass') AND
(obj.id=prop.id.id and prop.id.name='address' and prop.value like
'%someaddress%') AND
(obj.id=otherprop.id.id and otherprop.id.name='username')
order by otherprop.value
I stick parens in there for sanity's sake. I can always tell when I'm
working with one property vs. the other because of visual grouping. But
that's just me... ;)
Erin
------------------
DigitalGlue, India