topic Re: NXQL query in Nuxeo Forum

NXQL query

Nuxeo_User — Fri, 13 Oct 2017 09:44:28 GMT

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 — Fri, 13 Oct 2017 09:49:47 GMT

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 + "%'");

Nuxeo_User — Fri, 13 Oct 2017 10:37:38 GMT

Thanks Kevin it worked.But it receives an empty list.The xpath is not wrong .the parameter too.I don't get it