Hi,
I am querying for all the users whose addresses are matching a particular pattern. (there is an "address" property in the UserClass). Also I want to the results to be sorted by another property, "username".
I found a similar query in this mailing list thread : http://www.nabble.com/select-objects-by-class-and-sort-by-property-tf710844....
I tried forming the following query but it is wrong. , BaseObject as obj, StringProperty as prop, StringProperty as otherprop join obj.id=otherprop.id.id and otherprop.id.name='username' 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%' order by otherprop.value
Can anyone tell me what the correct query should be like.
Thanks in advance Roopesh
------------------ DigitalGlue, India
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 -- Waste of a good apple. --Samwise Gamgee