Re: [xwiki-users] Order by property of a class

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