NXQL query

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Nuxeo_User

Hi I am making a NXQL and passsing a parameter like this: session.query("SELECT * FROM document_type_name WHERE xpath_name LIKE " +parameter+"%");

But it throws an exception saying Syntax error : Invalid token at offset 50 Any idea?

Kevin_Leturc

Hi,

Stacktrace is always welcomed here. It could help to debug.

In your case, I think your missing the surrounding quotes. See the documentation examples.

In your case it would be:

session.query(“SELECT * FROM document_type_name WHERE xpath_name LIKE '" + parameter + "%'");