SELECT clause in NXQL queries
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”
Administrator@127.0.0.1:/> query “select dc:title from myDocumentType”
myDocumentType does have the dublincore schema, and the document has a non-emtpy dc:title… what am I missing?
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