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