Re: [xwiki-users] HQL order by object property
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 ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] HQL order by object property
Hitchhiking on this thread... Are there performance differences between the XWL and HQL? Thanks! 2014-08-28 4:49 GMT-03:00 vinc...@massol.net : > 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 (ddavid...@ranchsystems.com > (mailto:ddavid...@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: > > > > 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@xwiki.org > > > http://lists.xwiki.org/mailman/listinfo/users > > > > > > > > > > > -- > > Dale Davidson > > Technical Writer / Production Diagnostics > > www.RanchSystems.com > > ___ > > users mailing list > > users@xwiki.org > > http://lists.xwiki.org/mailman/listinfo/users > ___ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > -- Danilo Amaral de Oliveira Engenheiro de Computação celular (32) 9111 - 6867 ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] myxwiki sends multiple notification emails
I think it would be better, to change default XWiki settings in WEB-INF/xwiki.cfg for watchlists from major to none Valdis > Ok I think I found all of them this time. > > On Thu, Aug 28, 2014 at 9:32 AM, Thomas Mortagne > wrote: > > Looks like there was watchlist jobs on your wiki for some reason (they > > are supposed to be only on main wiki), I deleted them so that should > > be one less mail. There seems to be another wiki with that issue, not > > sure which one yet. > > > > On Tue, Jun 18, 2013 at 7:38 PM, Stefan Taferner > > wrote: > >> Hello all! > >> > >> We have an interesting problem with our myxwiki installation > >> (selfbus.myxwiki.org) > >> When one registers for notification emails, one gets 4 emails instead of > >> one. > >> Is there anything I can do to fix this behaviour? > >> > >> Thanks in advance, > >> Stefan > >> > >> ___ > >> users mailing list > >> users@xwiki.org > >> http://lists.xwiki.org/mailman/listinfo/users > > > > > > > > -- > > Thomas Mortagne > > > ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Can I remove these interface things?
Danilo Oliveira, Thanks a lot for the fast reply! Obrigado rs -- View this message in context: http://xwiki.475771.n2.nabble.com/Can-I-remove-these-interface-things-tp7591916p7591923.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Can I remove these interface things?
Hello Vandrey, Yes you can do that. You will need to modify or override the templates of colibri skin. See: https://network.xwiki.com/xwiki/bin/view/DocXCloud453En/CreateOverrideSkin You can disable the annotations , in the admin section: http://extensions.xwiki.org/xwiki/bin/view/Extension/Annotations+Application The tags, you can remove it changing the colibri template as well: check for the documentTags.vm template. Thanks, Danilo 2014-08-28 9:50 GMT-03:00 vandreytrindade : > Started to use XWiki yesterday as my boss asked me to. > > How (and where) can I change the logon page interface? > Wanted to remove that "search field" and change that spaced writings "L o g > - i n". > > http://i.imgur.com/tOGXy6K.png > > Also, can I remove that "Tags:" from the bottom of every page? > "Annotations" > at the top too? > > Sorry for the noob questions. > > > > -- > View this message in context: > http://xwiki.475771.n2.nabble.com/Can-I-remove-these-interface-things-tp7591916.html > Sent from the XWiki- Users mailing list archive at Nabble.com. > ___ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > -- Danilo Amaral de Oliveira Engenheiro de Computação celular (32) 9111 - 6867 ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Convert Xwiki 1.0 Syntax to 2.0
Dear vmassol, thank you! Kindly Regards, Lukas -- View this message in context: http://xwiki.475771.n2.nabble.com/Convert-Xwiki-1-0-Syntax-to-2-0-tp7591918p7591921.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Convert Xwiki 1.0 Syntax to 2.0
Hi, On 28 Aug 2014 at 15:17:45, tonyloveshisprivacy (lukas.kaltenb...@kesslernetworks.de(mailto:lukas.kaltenb...@kesslernetworks.de)) wrote: > Dear Xwiki Community, > > is there a way/tool with which I can convert Pages with Syntax Xwiki 1.0 to > Syntax 2.0 or 2.1? Yes it’s done automatically, see http://platform.xwiki.org/xwiki/bin/view/Features/PageEditing#HConvertingbetweenSyntaxes Thanks -Vincent > Kindly Regards, > tonyloveshisprivacy ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] Convert Xwiki 1.0 Syntax to 2.0
Dear Xwiki Community, is there a way/tool with which I can convert Pages with Syntax Xwiki 1.0 to Syntax 2.0 or 2.1? Kindly Regards, tonyloveshisprivacy -- View this message in context: http://xwiki.475771.n2.nabble.com/Convert-Xwiki-1-0-Syntax-to-2-0-tp7591918.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] Can I remove these interface things?
Started to use XWiki yesterday as my boss asked me to. How (and where) can I change the logon page interface? Wanted to remove that "search field" and change that spaced writings "L o g - i n". http://i.imgur.com/tOGXy6K.png Also, can I remove that "Tags:" from the bottom of every page? "Annotations" at the top too? Sorry for the noob questions. -- View this message in context: http://xwiki.475771.n2.nabble.com/Can-I-remove-these-interface-things-tp7591916.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] HQL order by object property
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 (ddavid...@ranchsystems.com(mailto:ddavid...@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: > > > 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@xwiki.org > > http://lists.xwiki.org/mailman/listinfo/users > > > > > > -- > Dale Davidson > Technical Writer / Production Diagnostics > www.RanchSystems.com > ___ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] myxwiki sends multiple notification emails
Ok I think I found all of them this time. On Thu, Aug 28, 2014 at 9:32 AM, Thomas Mortagne wrote: > Looks like there was watchlist jobs on your wiki for some reason (they > are supposed to be only on main wiki), I deleted them so that should > be one less mail. There seems to be another wiki with that issue, not > sure which one yet. > > On Tue, Jun 18, 2013 at 7:38 PM, Stefan Taferner > wrote: >> Hello all! >> >> We have an interesting problem with our myxwiki installation >> (selfbus.myxwiki.org) >> When one registers for notification emails, one gets 4 emails instead of >> one. >> Is there anything I can do to fix this behaviour? >> >> Thanks in advance, >> Stefan >> >> ___ >> users mailing list >> users@xwiki.org >> http://lists.xwiki.org/mailman/listinfo/users > > > > -- > Thomas Mortagne -- Thomas Mortagne ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] myxwiki sends multiple notification emails
Looks like there was watchlist jobs on your wiki for some reason (they are supposed to be only on main wiki), I deleted them so that should be one less mail. There seems to be another wiki with that issue, not sure which one yet. On Tue, Jun 18, 2013 at 7:38 PM, Stefan Taferner wrote: > Hello all! > > We have an interesting problem with our myxwiki installation > (selfbus.myxwiki.org) > When one registers for notification emails, one gets 4 emails instead of > one. > Is there anything I can do to fix this behaviour? > > Thanks in advance, > Stefan > > ___ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users -- Thomas Mortagne ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
