SELECT clause in NXQL queries

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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