topic Re: 5.6-RC3 Nuxeo Shell: is "SELECT dc:title FROM Document" a valid query?? in Nuxeo Forum

5.6-RC3 Nuxeo Shell: is "SELECT dc:title FROM Document" a valid query??

promanov_ — Tue, 21 Aug 2012 15:35:52 GMT

Hi all,

My question is simple. In 5.6-RC3 Nuxeo Shell, is the following command valid and must return results?

query "SELECT dc:title FROM Document"

I have some documents created (Case Management "Case" objects and others), but this query returns nothing. I've got results with "SELECT * FROM Document". Thanks.

Re: 5.6-RC3 Nuxeo Shell: is "SELECT dc:title FROM Document" a valid query??

Benjamin_Jalon1 — Tue, 28 Aug 2012 12:07:50 GMT

Query system is based on NXQL language.

This language is used to query the Document Repository and returned object are always documents.

I let you looking this documentation: http://doc.nuxeo.com/x/uItH

Hope this will help.

Re: 5.6-RC3 Nuxeo Shell: is "SELECT dc:title FROM Document" a valid query??

promanov_ — Tue, 28 Aug 2012 14:11:04 GMT

Thanks. I was on the way to this conclusion (that the results aren't fields but objects), the doc doesn't make it clear I find.