27 Aug
2014
27 Aug
'14
7:29 p.m.
Hello there, I've been banging my head against the desk a few days now
over this. I just can't find the answer online anywhere.
I'd like to perform an HQL query and use a number property of an object on
each document to sort my results. I understand SQL very well, but I just
need to know the object/property stucture -- exact syntax -- to use as the
order by argument. I followed the FAQ tutorial to create my class systeem,
and it all works fine, but I need to be able to display the records/objects
in order.
What I have:
#set($sql = ", BaseObject as obj, IntegerProperty as prop where obj.name =
doc.fullName and obj.className = 'Sensor Types.SensorTypeClass' and obj.name
<> 'Sensor Types.SensorTypeTemplate' order by ??? asc")
...except for the ??? of course. I've tried many things, but I can't
figure out the structure I need to place there.
The property I need to sort by is "TypeID" and is attached to the
SensorTypeClass, and is an integer.
Thanks in advance for any help anyone could lend me :)
--
Dale Davidson
Technical Writer / Production Diagnostics
www.RanchSystems.com
27 Aug
27 Aug
7:49 p.m.
On 08/27/2014 03:29 PM, Dale Davidson wrote:
Hello there, I've been banging my head against
the desk a few days now
over this. I just can't find the answer online anywhere.
I'd like to perform an HQL query and use a number property of an object on
each document to sort my results. I understand SQL very well, but I just
need to know the object/property stucture -- exact syntax -- to use as the
order by argument. I followed the FAQ tutorial to create my class systeem,
and it all works fine, but I need to be able to display the records/objects
in order.
What I have:
#set($sql = ", BaseObject as obj, IntegerProperty as prop where obj.name =
doc.fullName and obj.className = 'Sensor Types.SensorTypeClass' and obj.name
<> 'Sensor Types.SensorTypeTemplate' order by ??? asc")
prop is not joined in the query, this means you're getting horrible
performance if this is indeed your query. Perhaps that's your question,
what to write to get this property in the query? Is this what you're
looking for:
#set($sql = ", BaseObject as obj, IntegerProperty as prop where obj.name
= doc.fullName and obj.className = 'Sensor Types.SensorTypeClass' and
obj.name <> 'Sensor Types.SensorTypeTemplate'
and prop.id.id = obj.id and prop.id.name = 'TypeID' order by prop.value
asc")
In general you join properties with prop.id.id=obj.id, check the
property name with prop.id.name='propName', and get the value with
prop.value but this last part isn't always like this, there are two
exceptions:
- StringLists with multiple=true and relational=false use prop.textValue
- StringLists with multiple=true and relational=true use prop.list, but
you usually have to write:
, DBStringListProperty prop join prop.list list [...] prop.id.name =
'propName' and list = 'value'
...except for the ??? of course. I've tried many things, but I can't
figure out the structure I need to place there.
The property I need to sort by is "TypeID" and is attached to the
SensorTypeClass, and is an integer.
Thanks in advance for any help anyone could lend me :)
--
Sergiu Dumitriu
http://purl.org/net/sergiu
7:53 p.m.
Thank you, Sergiu! Directly after I sent my post, it clicked in my head.
I did indeed fail to perform the joins. What I have now is:
#set($sql = ", BaseObject as obj, IntegerProperty as prop where obj.name =
doc.fullName and obj.className = 'Sensor Types.SensorTypeClass' and obj.name
<> 'Sensor Types.SensorTypeTemplate' and obj.id=prop.id.id and
prop.id.name='TypeID'
and prop.value >0 order by prop.value asc ")
And it works exactly as I've been trying to make it work.
Thanks again for your quick reply! :D
On Wed, Aug 27, 2014 at 12:49 PM, Sergiu Dumitriu <sergiu(a)xwiki.org> wrote:
On 08/27/2014 03:29 PM, Dale Davidson wrote:
--
Dale Davidson
Technical Writer / Production Diagnostics
www.RanchSystems.com
Hello there, I've been banging my head
against the desk a few days now
over this. I just can't find the answer online anywhere.
I'd like to perform an HQL query and use a number property of an object
on
each document to sort my results. I understand
SQL very well, but I just
need to know the object/property stucture -- exact syntax -- to use as
the
order by argument. I followed the FAQ tutorial
to create my class
systeem,
and it all works fine, but I need to be able to
display the
records/objects
in order.
What I have:
#set($sql = ", BaseObject as obj, IntegerProperty as prop where obj.name
=
doc.fullName and obj.className = 'Sensor
Types.SensorTypeClass' and
obj.name
<> 'Sensor
Types.SensorTypeTemplate' order by ??? asc")
prop is not joined in the query, this means you're getting horrible
performance if this is indeed your query. Perhaps that's your question,
what to write to get this property in the query? Is this what you're
looking for:
#set($sql = ", BaseObject as obj, IntegerProperty as prop where obj.name
= doc.fullName and obj.className = 'Sensor Types.SensorTypeClass' and
obj.name <> 'Sensor Types.SensorTypeTemplate'
and prop.id.id = obj.id and prop.id.name = 'TypeID' order by prop.value
asc")
In general you join properties with prop.id.id=obj.id, check the
property name with prop.id.name='propName', and get the value with
prop.value but this last part isn't always like this, there are two
exceptions:
- StringLists with multiple=true and relational=false use prop.textValue
- StringLists with multiple=true and relational=true use prop.list, but
you usually have to write:
, DBStringListProperty prop join prop.list list [...] prop.id.name =
'propName' and list = 'value'
...except for the ??? of course. I've tried many things, but I can't
figure out the structure I need to place there.
The property I need to sort by is "TypeID" and is attached to the
SensorTypeClass, and is an integer.
Thanks in advance for any help anyone could lend me :)
--
Sergiu Dumitriu
http://purl.org/net/sergiu
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
28 Aug
28 Aug
7:49 a.m.
I’m curious, why don’t you use XWQL which we designed specifically to make it easy to
write such queries :)
See http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module
Thanks
-Vincent
On 27 Aug 2014 at 21:54:05, Dale Davidson
(ddavidson@ranchsystems.com(mailto:ddavidson@ranchsystems.com)) wrote:
Thank you, Sergiu! Directly after I sent my post, it
clicked in my head.
I did indeed fail to perform the joins. What I have now is:
#set($sql = ", BaseObject as obj, IntegerProperty as prop where obj.name =
doc.fullName and obj.className = 'Sensor Types.SensorTypeClass' and obj.name
<> 'Sensor Types.SensorTypeTemplate' and obj.id=prop.id.id and
prop.id.name='TypeID'
and prop.value >0 order by prop.value asc ")
And it works exactly as I've been trying to make it work.
Thanks again for your quick reply! :D
On Wed, Aug 27, 2014 at 12:49 PM, Sergiu Dumitriu wrote:
On 08/27/2014 03:29 PM, Dale Davidson wrote:
--
Dale Davidson
Technical Writer / Production Diagnostics
www.RanchSystems.com
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users Hello there, I've been banging my head
against the desk a few days now
over this. I just can't find the answer online anywhere.
I'd like to perform an HQL query and use a number property of an object
on
each document to sort my results. I understand
SQL very well, but I just
need to know the object/property stucture -- exact syntax -- to use as
the
order by argument. I followed the FAQ tutorial to
create my class
systeem,
and it all works fine, but I need to be able to
display the
records/objects
in order.
What I have:
#set($sql = ", BaseObject as obj, IntegerProperty as prop where obj.name
=
doc.fullName and obj.className = 'Sensor
Types.SensorTypeClass' and
obj.name
<> 'Sensor
Types.SensorTypeTemplate' order by ??? asc")
prop is not joined in the query, this means you're getting horrible
performance if this is indeed your query. Perhaps that's your question,
what to write to get this property in the query? Is this what you're
looking for:
#set($sql = ", BaseObject as obj, IntegerProperty as prop where obj.name
= doc.fullName and obj.className = 'Sensor Types.SensorTypeClass' and
obj.name <> 'Sensor Types.SensorTypeTemplate'
and prop.id.id = obj.id and prop.id.name = 'TypeID' order by prop.value
asc")
In general you join properties with prop.id.id=obj.id, check the
property name with prop.id.name='propName', and get the value with
prop.value but this last part isn't always like this, there are two
exceptions:
- StringLists with multiple=true and relational=false use prop.textValue
- StringLists with multiple=true and relational=true use prop.list, but
you usually have to write:
, DBStringListProperty prop join prop.list list [...] prop.id.name =
'propName' and list = 'value'
...except for the ??? of course. I've tried many things, but I can't
figure out the structure I need to place there.
The property I need to sort by is "TypeID" and is attached to the
SensorTypeClass, and is an integer.
Thanks in advance for any help anyone could lend me :)
--
Sergiu Dumitriu
http://purl.org/net/sergiu
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
7:04 p.m.
Hitchhiking on this thread...
Are there performance differences between the XWL and HQL?
Thanks!
2014-08-28 4:49 GMT-03:00 vincent(a)massol.net <vincent(a)massol.net>et>:
I’m curious, why don’t you use XWQL which we designed
specifically to make
it easy to write such queries :)
See http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module
Thanks
-Vincent
On 27 Aug 2014 at 21:54:05, Dale Davidson (ddavidson(a)ranchsystems.com
(mailto:ddavidson@ranchsystems.com)) wrote:
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Danilo Amaral de Oliveira
Engenheiro de Computação
celular (32) 9111 - 6867
Thank you, Sergiu! Directly after I sent my post,
it clicked in my head.
I did indeed fail to perform the joins. What I have now is:
#set($sql = ", BaseObject as obj, IntegerProperty as prop where obj.name
=
doc.fullName and obj.className = 'Sensor
Types.SensorTypeClass' and
obj.name
<> 'Sensor
Types.SensorTypeTemplate' and obj.id=prop.id.id and
prop.id.name='TypeID'
and prop.value >0 order by prop.value asc ")
And it works exactly as I've been trying to make it work.
Thanks again for your quick reply! :D
On Wed, Aug 27, 2014 at 12:49 PM, Sergiu Dumitriu wrote:
> On 08/27/2014 03:29 PM, Dale Davidson wrote:
> > Hello there, I've been banging my head against the desk a few days
now
> > over this. I just can't find the
answer online anywhere.
> >
> > I'd like to perform an HQL query and use a number property of an
object
> on
> > each document to sort my results. I understand SQL very well, but I
just
> > need to know the object/property
stucture -- exact syntax -- to use
as
> the
> > order by argument. I followed the FAQ tutorial to create my class
> systeem,
> > and it all works fine, but I need to be able to display the
> records/objects
> > in order.
> >
> > What I have:
> >
> > #set($sql = ", BaseObject as obj, IntegerProperty as prop where
obj.name
> > =
> > doc.fullName and obj.className =
'Sensor Types.SensorTypeClass' and
> > obj.name
> > > <> 'Sensor Types.SensorTypeTemplate' order by ???
asc")
> >
> > prop is not joined in the query, this means you're getting horrible
> > performance if this is indeed your query. Perhaps that's your question,
> > what to write to get this property in the query? Is this what you're
> > looking for:
> >
> > #set($sql = ", BaseObject as obj, IntegerProperty as prop where
obj.name
> = doc.fullName and obj.className =
'Sensor Types.SensorTypeClass' and
> obj.name <> 'Sensor Types.SensorTypeTemplate'
> and prop.id.id = obj.id and prop.id.name = 'TypeID' order by
prop.value
> asc")
>
> In general you join properties with prop.id.id=obj.id, check the
> property name with prop.id.name='propName', and get the value with
> prop.value but this last part isn't always like this, there are two
> exceptions:
>
> - StringLists with multiple=true and relational=false use
prop.textValue
-
StringLists with multiple=true and relational=true use prop.list, but
you usually have to write:
, DBStringListProperty prop join prop.list list [...] prop.id.name =
'propName' and list = 'value'
--
Dale Davidson
Technical Writer / Production Diagnostics
www.RanchSystems.com
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
...except for the ??? of course. I've tried many things, but I can't
figure out the structure I need to place there.
The property I need to sort by is "TypeID" and is attached to the
SensorTypeClass, and is an integer.
Thanks in advance for any help anyone could lend me :)
--
Sergiu Dumitriu
http://purl.org/net/sergiu
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
8:18 p.m.
On 08/28/14 15:04, Danilo Oliveira wrote:
Hitchhiking on this thread...
Are there performance differences between the XWL and HQL?
Depends. XWQL is just a meta-language, which gets translated to HQL, so
the execution time of an XWQL query is the same as the equivalent HQL
query. Two things change this balance:
1. Translating the query takes some time, though compared to the rest of
the process it's negligible
2. Manually written HQL queries could be different than what XWQL
translates to, either in a severely worse way by forgetting to write a
needed join, or in a slightly better way by avoiding useless joins and
where conditions when the author of the query really knows the data model
--
Sergiu Dumitriu
http://purl.org/net/sergiu
3720
days inactive
3721
days old
5 comments
5 participants
participants (5)
-
Dale Davidson -
Danilo Oliveira -
Sergiu Dumitriu -
Sergiu Dumitriu -
vincent＠massol.net