NXQL: SELECT * FROM Document returns only ecm:uuid property value : shouldn't it return all properties values?

[promanov_]

Hello,

I'm testing NXQL queries via Nuxel Shell on a slightly customized CMF 5.6-RC3 installation.

Is it normal that a query like following

 SELECT * FROM Case

returns only an id value (ecm:uuid) ?

   /case-management/case-root/2012/08/20/case 1
   /case-management/case-root/2012/08/20/case 2
   /case-management/case-root/2012/08/20/case 3
   ...

I'm trying to access other properties, starting from dc:title, but got an empty result.

SELECT dc:title FROM Case

What am I doing wrong? Isn't SELECT * supposed to return all properties values?

Thanks.

[promanov_]

may be it's described in the doc somebody could refer me to? I haven't found.

[Florent_Guillau · Accepted solution]

The query command in the Nuxeo Shell only returns documents (either their uuid or their path depending on the options).

You would need to define your own Shell command using an new Operation that uses queryAndFetch to get the result you want (this would be a useful contribution).

[promanov_]

OK.Thanks for this indication.