nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Find more posts tagged with

Accepted answers

Florent_Guillau

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

All comments

promanov_

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

Florent_Guillau

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.