parameterized NXQL queries

nuxeonovice_ — Tue, 08 May 2012 13:03:49 GMT

We have nuxeo queries which come from a constants file. A sample query is listed below.

public static final String GET_FILES_BY_PARENT ="SELECT * FROM File WHERE ecm:parentId = ?"

public static final String GET_FILES_BY_PARENT ="SELECT * FROM File WHERE ecm:parentId = :parentID"

How can I plugin in the parameters while excuting the query. We execute the query in the following manner.

Documents docs = (Documents) session.newRequest("Document.Query").set("query", GET_FILES_BY_PARENT).execute();

We can have more than one parameter in a query. How can we parameterize the query without ugly string manipulations.

Thanks

Re: parameterized NXQL queries

Florent_Guillau — Thu, 10 May 2012 14:24:36 GMT

It seems you're using Nuxeo Client and not coding server-side code.

I'm not aware of any helper to build parametrized queries for Nuxeo Client. On the server side there's NXQLQueryBuilder.