You need to send messages to both me and xwiki-users list. Everybody should share knowledges.
What I want to do is extract all object of a class from a specific page, not the entire objects from the wiki database. How should I modify the query in this case? And where can I find all those XWQL object model references? (Yes, it reminds me of DOM) doc.object, etc, ... On Tue, Nov 13, 2012 at 5:59 PM, Jeremie BOUSQUET < jeremie.bousq...@gmail.com> wrote: > Well, it's not because the name is the same that it's the same method or > API ... :) > > XWiki core api is a Java api, available to components and scripts > (velocity, groovy ...). It provides access to documents as well as various > features of the wiki. > > XWQL is a query language, superset of JPQL (Java Persistence Query > Language ?) with some differences. You use it to query the data stored in > the database. > One of the differences between jpql/xwql is the syntax > "doc.object(MyClass)" that selects all XObjects belonging to a particular > XClass from the database. Apart from that, if you know JPQL then you mostly > know XWQL. > > ("doc.getObject("MyClass")" , from java api, retrieves XObjects of a > particular XClass from specified document only (and not from the whole > wiki).) > > > > 2012/11/13 crocket <crockabisc...@gmail.com> > >> Isn't doc.object(Class) part of XWiki core API? >> I thought it was an alias of $doc.getObject("Class") >> >> I want to know what APIs XWQL has access to, but I couldn't find the >> information. >> On Mon, Nov 12, 2012 at 11:42 PM, Jeremie BOUSQUET < >> jeremie.bousq...@gmail.com> wrote: >> >>> doc.getObjects("MyClass") is from the xwiki core java api, but is not >>> part of the XWQL querying language. >>> >>> The query: >>> >>> select srv.port from Document doc, doc.object(Private.Network Services) >>> as srv order by srv.port >>> >>> ... translates to " select "port" field from all XObjects that are of >>> class "Private.Network Services", ordering by "port" field " >>> So this query would retrieve the value of "port" field from all of these >>> XObjects (that we name "srv" in the query), wherever they are and whatever >>> their count. >>> >>> >>> >>> >>> 2012/11/12 crocket <crockabisc...@gmail.com> >>> >>>> doc.getObjects was there since I had multiple instance of the same >>>> class. >>>> >>>> >>>> >>>> On Mon, Nov 12, 2012 at 8:32 PM, Jeremie BOUSQUET < >>>> jeremie.bousq...@gmail.com> wrote: >>>> >>>>> Hello, >>>>> >>>>> I think this is not correct: >>>>> select srv from IN (doc.getObjects("Private.Network Services")) srv >>>>> order >>>>> by srv.port >>>>> >>>>> Should be more something like: >>>>> select srv.port from Document doc, doc.object(Private.Network >>>>> Services) as >>>>> srv order by srv.port >>>>> >>>>> Replacing the "select srv.port" by what fields you want to retrieve. >>>>> >>>>> Though obviously I'm not sure about what you wanted to achieve with >>>>> your >>>>> request to start with ... >>>>> >>>>> Br, >>>>> Jeremie >>>>> >>>>> >>>>> 2012/11/12 crocket <crockabisc...@gmail.com> >>>>> >>>>> > Yes, I read it, and it seems collection member declarations don't >>>>> work in >>>>> > xwiki. >>>>> > >>>>> > >>>>> > On Mon, Nov 12, 2012 at 6:13 PM, Jerome Velociter < >>>>> jer...@velociter.fr >>>>> > >wrote: >>>>> > >>>>> > > Le 12/11/12 09:37, crocket a écrit : >>>>> > > >>>>> > > I tried to execute a Query and saw an error below. >>>>> > >> >>>>> > >> Caused by: org.xwiki.query.**QueryException: Exception while >>>>> translating >>>>> > >> [select srv from IN (doc.getObjects("Private.**Network >>>>> Services")) srv >>>>> > >> order by srv.port] XWQL query to the [hql] language. Query >>>>> statement = >>>>> > >> [select srv from IN (doc.getObjects("Private.**Network >>>>> Services")) srv >>>>> > >> order by srv.port] >>>>> > >> >>>>> > >> Although I read JPQL documents, I couldn't come out with an >>>>> answer. >>>>> > >> >>>>> > >> Does anybody know how to write a correct XWQL statement? >>>>> > >> >>>>> > > >>>>> > > Have you read >>>>> http://extensions.xwiki.org/**xwiki/bin/view/Extension/** >>>>> > > Query+Module#**HQueryLanguageExamples< >>>>> > >>>>> http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module#HQueryLanguageExamples >>>>> > >? >>>>> > > >>>>> > > Jerome >>>>> > > >>>>> > >> ______________________________**_________________ >>>>> > >> users mailing list >>>>> > >> users@xwiki.org >>>>> > >> http://lists.xwiki.org/**mailman/listinfo/users< >>>>> > http://lists.xwiki.org/mailman/listinfo/users> >>>>> > >> >>>>> > > >>>>> > > ______________________________**_________________ >>>>> > > users mailing list >>>>> > > users@xwiki.org >>>>> > > http://lists.xwiki.org/**mailman/listinfo/users< >>>>> > http://lists.xwiki.org/mailman/listinfo/users> >>>>> > > >>>>> > _______________________________________________ >>>>> > 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 >>>>> >>>> >>>> >>> >> > _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users