SELECT clause in NXQL queries

[franck102_]

I must be missing something very obvious with NXQL queries, because whenever I try to use anything but "SELECT *" as my select clause I get an empty result set:

`Administrator@127.0.0.1:/> query "select * from myDocumentType"

/default-domain/workspaces/Library/sections/North America

Administrator@127.0.0.1:/> query "select dc:title from myDocumentType"

Administrator@127.0.0.1:/>`

myDocumentType does have the dublincore schema, and the document has a non-emtpy dc:title... what am I missing?

Thanks!

[Laurent_Doguin]

Hi Franck,

you can have a specific select clause only when you call the method CoreSession.CoreSession#queryAndFetch. Unfortunately the search made from the shell uses CoreSession.query. You'll find more details here: http://dev.blogs.nuxeo.com/2012/10/qa-friday-select-clause-nuxeo-nxql-queries.html