14 Nov
2012
14 Nov
'12
1:20 p.m.
But how do I find the names of those corresponding models used in queries?
xwikidoc doesn't really remind me of Document, and I don't know how to
refer to xwikircs in queries.
On Wed, Nov 14, 2012 at 5:48 PM, Jeremie BOUSQUET <
jeremie.bousquet(a)gmail.com> wrote:
2012/11/13 crocket <crockabiscuit(a)gmail.com>
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, ...
Query language elements are the ones of JPQL + the differences described
in the Query Module page.
Now for the model, you can refer to the hibernate mapping (mapping from
xwiki api model to database model):
https://github.com/xwiki/xwiki-platform/blob/master/xwiki-platform-core/xwi…
On Tue, Nov 13, 2012 at 5:59 PM, Jeremie BOUSQUET <
jeremie.bousquet(a)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 <crockabiscuit(a)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.bousquet(a)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 <crockabiscuit(a)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.bousquet(a)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 <crockabiscuit(a)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 <
>>> jerome(a)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#HQueryLan…
>>> > >?
>>> > >
>>> > > Jerome
>>> > >
>>> > >> ______________________________**_________________
>>> > >> users mailing list
>>> > >> users(a)xwiki.org
>>> > >> http://lists.xwiki.org/**mailman/listinfo/users<
>>> > http://lists.xwiki.org/mailman/listinfo/users>
>>> > >>
>>> > >
>>> > > ______________________________**_________________
>>> > > users mailing list
>>> > > users(a)xwiki.org
>>> > > http://lists.xwiki.org/**mailman/listinfo/users<
>>> > http://lists.xwiki.org/mailman/listinfo/users>
>>> > >
>>> > _______________________________________________
>>> > users mailing list
>>> > users(a)xwiki.org
>>> > http://lists.xwiki.org/mailman/listinfo/users
>>> >
>>> _______________________________________________
>>> users mailing list
>>> users(a)xwiki.org
>>> http://lists.xwiki.org/mailman/listinfo/users
>>>
>>
>>
>