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

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.

0 votes

1 answers

3886 views

ANSWER

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



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).

0 votes



OK.Thanks for this indication.
08/30/2012