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

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

promanov_ — Mon, 20 Aug 2012 15:19:39 GMT

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.

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

promanov_ — Wed, 22 Aug 2012 22:10:44 GMT

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

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

Florent_Guillau — Thu, 30 Aug 2012 19:29:50 GMT

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

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

promanov_ — Thu, 30 Aug 2012 19:36:19 GMT

OK.Thanks for this indication.