Order by property of a class - xwiki-users@xwiki.org

Erin Schnabel

12 Jul 12 Jul

4:59 p.m.

New subject: [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

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

Reply

Mike Oliver

25 May 25 May

3:04 p.m.

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

Ok maybe I need a new set of eyes, but the following works and returns all the toolbar documents... #set ($hql = ", BaseObject as obj, StringProperty prop where obj.name=doc.fullName and obj.className='XWiki.ToolbarClass' and obj.name<>'XWiki.ToolbarClassTemplate' and obj.id=prop.id.id") The ToolbarClass has a Number Property called 'Order' but this doesn't work... #set ($hql = ", BaseObject as obj, StringProperty prop where obj.name=doc.fullName and obj.className='XWiki.ToolbarClass' and obj.name<>'XWiki.ToolbarClassTemplate' and obj.id=prop.id.id and prop.id.name='Order'") Erin Schnabel-3 wrote:

...

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 -- 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

-- View this message in context: http://www.nabble.com/Order-by-property-of-a-class-tp11559782p17457718.html Sent from the XWiki- Users mailing list archive at Nabble.com.

Reply

Mike Oliver

4:04 p.m.

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

I didn't find the documentation, but I did experiment and LongProperty does work, and looking at the Class I created the Number property does have an attribute type of number long...doe. Mike Oliver wrote:

...

Oh and BTW I did try NumberProperty which isn't mapped and BaseProperty which didn't execute. I also searched for and didn't find a list of the Property Types in the Documentation. Mike Oliver wrote:

Ok maybe I need a new set of eyes, but the following works and returns all the toolbar documents... #set ($hql = ", BaseObject as obj, StringProperty prop where obj.name=doc.fullName and obj.className='XWiki.ToolbarClass' and obj.name<>'XWiki.ToolbarClassTemplate' and obj.id=prop.id.id") The ToolbarClass has a Number Property called 'Order' but this doesn't work... #set ($hql = ", BaseObject as obj, StringProperty prop where obj.name=doc.fullName and obj.className='XWiki.ToolbarClass' and obj.name<>'XWiki.ToolbarClassTemplate' and obj.id=prop.id.id and prop.id.name='Order'") Erin Schnabel-3 wrote:

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 -- 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

-- View this message in context: http://www.nabble.com/Order-by-property-of-a-class-tp11559782p17458218.html Sent from the XWiki- Users mailing list archive at Nabble.com.

Reply