Hi,
I am doing a search for all the users whose address is matching a particular pattern.
(Suppose there is an "address" property in the UserClass). Also I want the
results to be sorted by another property, say, "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