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 [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?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.