[xwiki-users] How do I write a correct XWQL statement?
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?
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#HQueryLang... ? Jerome
_______________________________________________ users mailing list [email protected] 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 <[email protected]>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 [email protected] http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/mailman/listinfo/users>
______________________________**_________________ users mailing list [email protected] http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/mailman/listinfo/users>
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 <[email protected]>
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 <[email protected]
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#HQueryLang... ?
Jerome
______________________________**_________________ users mailing list [email protected] http://lists.xwiki.org/**mailman/listinfo/users<; http://lists.xwiki.org/mailman/listinfo/users>
______________________________**_________________ users mailing list [email protected] http://lists.xwiki.org/**mailman/listinfo/users<; http://lists.xwiki.org/mailman/listinfo/users>
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
doc.getObjects was there since I had multiple instance of the same class. On Mon, Nov 12, 2012 at 8:32 PM, Jeremie BOUSQUET < [email protected]> 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 <[email protected]>
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 <[email protected]
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#HQueryLang...
?
Jerome
______________________________**_________________ users mailing list [email protected] http://lists.xwiki.org/**mailman/listinfo/users<; http://lists.xwiki.org/mailman/listinfo/users>
______________________________**_________________ users mailing list [email protected] http://lists.xwiki.org/**mailman/listinfo/users<; http://lists.xwiki.org/mailman/listinfo/users>
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
participants (3)
-
crocket -
Jeremie BOUSQUET -
Jerome Velociter