Debugging: is it possible to trace all executed NXQL?

[promanov_]

Is there a debug flag to activate tracing of executed NXQL queries? I'd like to see the queries with resolved parameters.

In case the params variables don't contain the expected values, the query can return empty result without any errors. These errors aren't easy to spot and analyse.

I was wondering how to trace resulting NXQL queries after EL resolution.

Any idea? Thanks.

[Vladimir_Pasqui · Accepted solution]

Hi,

You can find the log4j xml configuration here: nuxeo/lib

Add these lines, and it should traced all nxql queries:

  <category name="org.nuxeo.ecm.platform.query">
    <priority value="TRACE" />
  </category>

[promanov_]

Thanks for the fast response!