12 Jul
2007
12 Jul
'07
3:01 p.m.
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
12 Jul
12 Jul
4:20 p.m.
New subject: [xwiki-users] Sorting by property of a class
Do you get a syntax error on that 'join' expression? I don't think
that's legal HQL, and whether it is or not you can get the desired
result by putting the obj.id = otherprop.id.id expression in the "where"
clause with the other qualifiers (note that the same thing is done with
the 'prop' alias, which is also a join to get the address field).
brain[sic]
-----Original Message-----
From: roopesh(a)digitalglue.in [mailto:roopesh@digitalglue.in]
Sent: Thursday, July 12, 2007 8:01 AM
To: xwiki-users(a)objectweb.org
Subject: [xwiki-users] Sorting by property of a class
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-prop
erty-tf710844.html#a1871554
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
13 Jul
13 Jul
1:13 a.m.
New subject: [xwiki-users] Sorting by property of a class
Indeed. This gives:
, 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
otherprop.id.id=obj.id and otherprop.id.name='username' order by
otherprop.value
On 7/12/07, THOMAS, BRIAN M (ATTSI) <bt0008(a)att.com> wrote:
Do you get a syntax error on that 'join'
expression? I don't think
that's legal HQL, and whether it is or not you can get the desired
result by putting the obj.id = otherprop.id.id expression in the "where"
clause with the other qualifiers (note that the same thing is done with
the 'prop' alias, which is also a join to get the address field).
brain[sic]
Sergiu
--
http://purl.org/net/sergiu
-----Original Message-----
From: roopesh(a)digitalglue.in [mailto:roopesh@digitalglue.in]
Sent: Thursday, July 12, 2007 8:01 AM
To: xwiki-users(a)objectweb.org
Subject: [xwiki-users] Sorting by property of a class
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-prop
erty-tf710844.html#a1871554
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
9:38 a.m.
New subject: [xwiki-users] Sorting by property of a class
In addition to my previous mail :
Now I tried sorting on another field 'companyname' as follows :
, BaseObject as obj, StringProperty as prop, StringProperty as otherprop
where doc.web='Companies' and obj.name=doc.fullName and
obj.className='Companyprofiles.companyprofilesClass' and
obj.id=prop.id.id and prop.id.name='companytags' and ( prop.value like
'%oil%' or prop.value like '%transportation%') and
otherprop.id.id=obj.id and otherprop.id.name='companyname' order by
otherprop.value desc
It did give me all the results which has the specified 'companytags' but
_not_ in the sorted order.
Some information that might help identify the problem. When I tried
sorting by 'rating' there were no results at all. Rating is a property
that I added recently to the 'companyprofilesClass'. And I am feeding in
the rating value programatically as follows
$doc.getObject("Companyprofiles.companyprofilesClass",0).set("rating",
$score)
Regards
Roopesh
Sergiu Dumitriu wrote:
Indeed. This gives:
, 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
otherprop.id.id=obj.id and otherprop.id.name='username' order by
otherprop.value
On 7/12/07, THOMAS, BRIAN M (ATTSI) <bt0008(a)att.com> wrote:
------------------
DigitalGlue, India
Do you get a syntax error on that 'join'
expression? I don't think
that's legal HQL, and whether it is or not you can get the desired
result by putting the obj.id = otherprop.id.id expression in the "where"
clause with the other qualifiers (note that the same thing is done with
the 'prop' alias, which is also a join to get the address field).
brain[sic]
Sergiu
------------------------------------------------------------------------
--
You receive this message as a subscriber of the xwiki-users(a)objectweb.org mailing list.
To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
-----Original Message-----
From: roopesh(a)digitalglue.in [mailto:roopesh@digitalglue.in]
Sent: Thursday, July 12, 2007 8:01 AM
To: xwiki-users(a)objectweb.org
Subject: [xwiki-users] Sorting by property of a class
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-prop
erty-tf710844.html#a1871554
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
6372
days inactive
6373
days old
3 comments
4 participants
participants (4)
-
Roopesh P Raj -
roopesh＠digitalglue.in
-
Sergiu Dumitriu -
THOMAS, BRIAN M (ATTSI)