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@> query “select * from myDocumentType”

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

Administrator@> 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?


0 votes

1 answers



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:

0 votes