Archive for September, 2011

From the start, as we think it's important for a real content management platform, Nuxeo has had the ability to send requests to the document repository using a SQL-like language that we call NXQL. This allows you to do things like:

SELECT * FROM Document WHERE dc:title = 'Some Report'

or:

SELECT * FROM Document WHERE dc:modified > DATE '2011-08-01'

or more complex:

SELECT * FROM Note WHERE dc:modified > TIMESTAMP '2011-08-01 12:43:38' AND ecm:fulltext = 'merger OR ipo' AND dc:lastContribtor IN ('bob', 'john') AND (m:priority BETWEEN 1 AND 5 OR m:level > 1000)

Of course you can mix all standard operators, add parentheses, OR, etc. More details about NXQL are available at http://doc.nuxeo.com/x/uItH.

But one limitation of NXQL used to be that, although Nuxeo can store and retrieve "deep" complex properties in its documents, there was no immediate way to use them in queries written in … Read more