12 Nov
2012
12 Nov
'12
9:37 a.m.
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?
12 Nov
12 Nov
10:13 a.m.
New subject: [xwiki-users] How do I write a correct XWQL statement?
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#HQueryLan…
?
Jerome
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
11:47 a.m.
New subject: [xwiki-users] How do I write a correct XWQL statement?
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;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/…
Jerome
______________________________**_________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/m…
______________________________**_________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/m…
12:32 p.m.
New subject: [xwiki-users] How do I write a correct XWQL statement?
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
______________________________**_________________
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
wrote:
Le 12/11/12 09:37, crocket a écrit :
I tried to execute a Query and saw an error below.
http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module#HQueryLan…
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< ?
Jerome
> ______________________________**_________________
> users mailing list
> users(a)xwiki.org
> http://lists.xwiki.org/**mailman/listinfo/users<
http://lists.xwiki.org/mailman/listinfo/users>
2:01 p.m.
New subject: [xwiki-users] How do I write a correct XWQL statement?
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>
http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module#HQueryLan…
______________________________**_________________
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
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
translating
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 >> [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<
?
Jerome
> ______________________________**_________________
> users mailing list
> users(a)xwiki.org
> http://lists.xwiki.org/**mailman/listinfo/users<
http://lists.xwiki.org/mailman/listinfo/users>
4379
days inactive
4379
days old
4 comments
3 participants
participants (3)
-
crocket -
Jeremie BOUSQUET -
Jerome Velociter