SELECT clause in NXQL queries

franck102_ — Fri, 05 Oct 2012 15:37:58 GMT

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!

Re: SELECT clause in NXQL queries

Laurent_Doguin — Mon, 08 Oct 2012 07:20:10 GMT

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

topic Re: SELECT clause in NXQL queries in Nuxeo Forum

SELECT clause in NXQL queries

Re: SELECT clause in NXQL queries