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”
/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!
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
 |
Laurent Doguin
Member (6.6K) 2 5 5 |
10/08/2012 ( History) |