- xwiki-users@xwiki.org - lists.xwiki.org

[xwiki-users] Re : XWQL query on several objects of the same class instantiated in the same doc
by BOUSQUET Jeremie 31 May '13

31 May '13

Hi, You miss the .execute() at the end :) Br, Jeremie Envoyé depuis mon HTC ----- Reply message ----- De : "Ricardo.Julio.Rodriguez.Fernandez(a)sergas.es" <Ricardo.Julio.Rodriguez.Fernandez(a)sergas.es> Pour : "users(a)xwiki.org" <users(a)xwiki.org> Cc : "Isabel.Lista.Garcia(a)sergas.es" <Isabel.Lista.Garcia(a)sergas.es> Objet : [xwiki-users] XWQL query on several objects of the same class instantiated in the same doc Date : mer., mai 22, 2013 21:24 Louis-Marie, Edo, thanks again! Louis-Marie, you perfectly understand what I'm trying to get: to use comments on documents as criteria for selection. I understand comments are not intended to satisfy this objetive, but, at least for me, they are extremely useful to "draft" data models to be implemented in new XWiki classes. Just a kind of "extreme development" tool! :-) I think the "only" problem we are facing with this use is the kind of queries combining comments on the same document to retrive documents and properties of any class there instantiated. I'm truly learning a lot! I think I can understand the construction and it must answer the well-formed question Louis-Marie wrote down in his message, but I'm not able to understand the result. Here what I get... org.xwiki.query.internal.DefaultQuery@70687068 The integer after the @ changes it time I reload the page. I din't get neither a document fullName, nor an object. You can always check it in the same link posted before... http://www.idisantiago.es/bin/XWQL/SnapshotE0012012 In found DefaultQuery code here... http://maven.xwiki.org/site/clover/20120701/clover-platform-20120702/org/xw… Perhaps this construct doesn't work in my plain old XWIKI ENTERPRISE 2.4.30451 installation? Thanks for your help! Ricardo > ________________________________________ > From: users-bounces(a)xwiki.org [users-bounces(a)xwiki.org] On Behalf Of Guillaume "Louis-Marie" Delhumeau [gdelhumeau(a)xwiki.com] > Sent: 22 May 2013 17:51 > To: XWiki Users > Subject: Re: [xwiki-users] XWQL query on several objects of the same class instantiated in the same doc > > Hi. > > I'm not sure I really understood what you need to do, but let me propose a > solution anyway. > > I think what you need is to get the all the documents that contains > comments with "%doc.title%" content and where there is NO comment with > '%Withdrawal:2011% in the content. > > So, that's how I would solve the problem: > > #set ($xwlquery1 = "FROM doc.object(XWiki. > XWikiComments) AS commWHERE doc.translation = 0 AND and comm.comment LIKE > :doctitle AND doc.fullName NOT IN (SELECT doc2.fullName FROM Document doc2, > doc2.object(XWiki.XWikiComments) comm2 WHERE comm2.comment LIKE > '%Withdrawal:2011%')") > #set($results = $services.query.xwql($xwqlquery1).bindValue('doctitle', > "%${doc.title}%")) > > I didn't test it but it should work. > > Louis-Marie. > > 2013/5/22 <Ricardo.Julio.Rodriguez.Fernandez(a)sergas.es> > >> Hi! Thanks you both for answering! >> >> I'm afraid that your proposals didn't solve the problem. Please, see >> here... >> >> http://www.idisantiago.es/bin/XWQL/SnapshotE0012012 >> >> Both users have three comments each. This way: >> >> XWD_ID:416379378 >> Gender:xxxxxxxx >> Withdrawal:20121017 >> Formely:XWiki.XWikiIDISE001 >> >> XWD_ID:946660794 >> Gender:xxxxxxxx >> Withdrawal:20111231 >> Formely:XWiki.XWikiIDISE001 >> >> Thus, I'm still not able to design a query to retrive ONLY user >> XWD_ID:416379378 based on comments :-( Your proposals answer with a list >> including both users n times. I'm not able neither of explain n in both >> cases... any idea will be welcome! >> >> Thank you very much for your help, >> >> Ricardo >> >> >> > ________________________________________ >> > From: users-bounces(a)xwiki.org [users-bounces(a)xwiki.org] On Behalf Of >> Guillaume "Louis-Marie" Delhumeau [gdelhumeau(a)xwiki.com] >> > Sent: 22 May 2013 13:02 >> > To: XWiki Users >> > Subject: Re: [xwiki-users] XWQL query on several objects of the same >> class instantiated in the same doc >> > >> > Hi Ricardo and Edo, >> > >> > 2013/5/22 Edo Beutler <ebeutler(a)synventis.com> >> > >> >> Hi Ricardo >> >> >> >> You are only checking in one object. So there has to be one object that >> >> contains the doc name, but not the withdrawal part which is fulfilled by >> >> the third object in your example. Whilst I don't recall ever having >> tried >> >> checking for multiple objects in XWQL, I would suspect this should work: >> >> >> >> #set ($xwlquery1 = "from doc.object(XWiki.XWikiComments) as comm1, >> >> doc.object(XWiki.XWikiComments) as comm2 where doc.translation = 0 and >> >> comm1.comment like '%$doc.title%' and comm2.comment not like >> >> '%Withdrawal:2011%'") >> >> >> > >> > You are right. But I think you should add "comm1 <> comm2" in your query >> to >> > make it work. >> > >> > Louis-Marie Nota: A información contida nesta mensaxe e os seus posibles documentos adxuntos é privada e confidencial e está dirixida únicamente ó seu destinatario/a. Se vostede non é o/a destinatario/a orixinal desta mensaxe, por favor elimínea. A distribución ou copia desta mensaxe non está autorizada. Nota: La información contenida en este mensaje y sus posibles documentos adjuntos es privada y confidencial y está dirigida únicamente a su destinatario/a. Si usted no es el/la destinatario/a original de este mensaje, por favor elimínelo. La distribución o copia de este mensaje no está autorizada. See more languages: http://www.sergas.es/aviso_confidencialidad.htm _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

4 14

[xwiki-users] [ANN] XWiki 5.1 Milestone 1 Released
by Marius Dumitru Florea 31 May '13

31 May '13

The XWiki development team is proud to announce the availability of XWiki 5.1 Milestone 1. This release brings an improved Solr search UI with faceted search and a couple of bug fixes and other small improvements. You can download it here: http://www.xwiki.org/xwiki/bin/view/Main/Download Make sure to review the release notes: http://www.xwiki.org/xwiki/bin/view/ReleaseNotes/ReleaseNotesXWiki51M1 Thanks -The XWiki dev team

1 0

[xwiki-users] New Wysiwyg Editor in an Old version of Xwiki platform
by Boudjelda Mohamed Said 30 May '13

30 May '13

Hi Devs and Users Sorry for this question if it seems stupid :) I have an old version of xwiki platform that have of course an old wysiwyg editor , and I wanted to replace it with the new editor from the last version of Xwiki witch is more enhanced then the old one I this possible? any one want to share his experience about that topic , what are impacts on other parts of the framework Thanks

2 1

[xwiki-users] Multi-select files to upload
by Hamster 30 May '13

30 May '13

We want to create our workinstructions by displaying photo's in the Lightbox Macro <http://extensions.xwiki.org/xwiki/bin/view/Extension/Lightbox+Macro> . Each photo is one step of the workinstruction. One workinstruction may have 50 steps, so we need to upload 50 photo's (just for that one workinstruction) We have dozens of workinstructions, so my users aks me why they have to select each file one-by-one. Is there a "multi-select" option to quickly select and upload multiple files to an XWiki page? Or can I drag-and-drop files into an XWiki page? -- View this message in context: http://xwiki.475771.n2.nabble.com/Multi-select-files-to-upload-tp7585505.ht… Sent from the XWiki- Users mailing list archive at Nabble.com.

2 3

[xwiki-users] Creating a page with dot on the Title
by Art Yeung 30 May '13

30 May '13

Hi all, When I create a page in a Space called "MySpace" using Title "a.b.c" , it created a page call "c" under the space "a.b". (a.b: c) Is there anyway I can allow users create document with dot on the Title please? I would expect the document to be called "MySpace: a.b.c" Many Thanks Art -- View this message in context: http://n2.nabble.com/Creating-a-page-with-dot-on-the-Title-tp1112070p111207… Sent from the XWiki- Users mailing list archive at Nabble.com.

4 4

[xwiki-users] Page, Space or Wiki MindMap Tutorial
by Belkhiria Hamza Yazid 28 May '13

28 May '13

Hi, I read the freemind macro and mindmap macros still there is no clear beginner documentation yet on how to generate a mindmap of a space, of a wiki or of a page, Can anybody give assistance in regards of this ? Thanks -- *BHY*

1 1

[xwiki-users] Error in SpaceExplorer Extension
by muxodo＠googlemail.com 27 May '13

27 May '13

Hi All, I just installed a new xwiki on glassfish and postgresql. I need a tree based navigation, so i installed Space Explorer. But it shows an error when it tries to load the menu: Server returned TRANSPORT_ERROR with no error message. How can I fix this? Or how can I implement another Tree Navigation? Thanks! Heiko

2 1

[xwiki-users] Parent Children Livetable Macro
by Belkhiria Hamza Yazid 27 May '13

27 May '13

HI, Is there a way to apply this macro in order to show parent children for a specific page rather than a space ? Best Regards -- *BHY*

2 3

[xwiki-users] javascript parameter
by pierrick.bena＠intech.lu 27 May '13

27 May '13

Hi everybody, I would like to send a javascript parameter with this jQuery method : $.ajax({ url: "myurl", dataType: "json", data: {"myparameter" : "value"}, beforeSend : function(xhr) { xhr.setRequestHeader("Authorization", "Basic " + coded); } }) Do you know how I could get the parameter "myparameter" back and use its value in a velocity script ? I don't know if it's possible or not. Thanks in advance for your help. Regards, Pierrick

2 1

[xwiki-users] HQL query on DBTreeList
by pierrick.bena＠intech.lu 27 May '13

27 May '13

Hi again ! I have several "Blog.BlogPostClass" objects and I try to make an HQL query in order to get BlogPosts which belong to a particular category. This is the category property of my objects : <property type="DBTreeList" name="category"> <link rel="self" href="http://192.168.11.34:8080/xwiki/rest/wikis/xwscomintech/spaces/Blog/pages/%…"/> <attribute value="category" name="name"/><attribute value="Category" name="prettyName"/> <attribute value="0" name="unmodifiable"/> <attribute value="0" name="disabled"/> <attribute value="1" name="relationalStorage"/> <attribute value="input" name="displayType"/> <attribute value="1" name="multiSelect"/> <attribute value="1" name="size"/> <attribute value=", " name="separator"/> <attribute value="0" name="cache"/> <attribute value="Blog.CategoryClass" name="classname"/> <attribute value="" name="customDisplay"/> <attribute value="doc.fullName" name="idField"/> <attribute value="4" name="number"/> <attribute value="doc.parent" name="parentField"/> <attribute value="1" name="picker"/> <attribute value="" name="separators"/> <attribute value="value" name="sort"/> <attribute value="" name="sql"/> <attribute value="" name="tooltip"/> <attribute value="" name="validationMessage"/> <attribute value="" name="validationRegExp"/> <attribute value="name" name="valueField"/> <attribute value="Blog.Categories,Blog.CategoryTemplate,Blog.News,Blog.Other,Blog.Personal" name="allowedValues"/> <value>Blog.Réunions thématiques</value></property> I would like to list BlogPosts in "Blog.Réunions thématiques" I tried this query : #set($hql = ", BaseObject as obj, DateProperty as prop1, StringProperty as prop2 where doc.fullName=obj.name and obj.className='Blog.BlogPostClass' and obj.id=prop1.id.id and obj.id=prop2.id.id and prop2.id.name='category' and prop2.value='Blog.Réunions thématiques' and prop1.id.name='publishDate' and prop1.value is not null and doc.space='Blog' order by prop1.value desc ") I saw that the type of my property was "DBTreeList" so I tried to replace StringProperty by DBStringListProperty but no success ... I need help please :-) Thanks

2 2