Steps

Read the SQL query a Live Data built on the liveTable source actually ran, when it returns the wrong entries, with edit right on XWiki.LiveTableResultsMacros and access to the "Logging" administration section.

1. Open the browser developer tools on the page holding the Live Data, select the "Network" tab and filter on /entries to find the URL it fetches its entries from.
2. Open that URL in a new tab, with &sourceParams.sql=1 appended to its query string.
3. Edit XWiki.LiveTableResultsMacros, find request.sql and add these two lines next to it:

   #set ($discard = $services.logging.getLogger('XWiki.LiveTableResultsMacros').debug("SQL: $sql"))
   #set ($discard = $services.logging.getLogger('XWiki.LiveTableResultsMacros').debug("SQL parameters: $sqlParams"))

4. Open the "Logging" administration section, search for the XWiki.LiveTableResultsMacros logger and set its level to debug.
5. Reload the entries URL. The server logs then hold the query and its parameters:

   DEBUG X.LiveTableResultsMacros       - SQL:   where 1=1    order by lower(doc.fullName) asc, doc.fullName asc
   DEBUG X.LiveTableResultsMacros       - SQL parameters: {}

6. Remove the two lines from XWiki.LiveTableResultsMacros and reset the logger level.

FAQ

Why can I not just add sql=1 as I would with a live table?

Because the parameter reaches the results page, but the Live Data does not display the extra field it adds to the JSON response.

Nothing is written to the logs. What did I miss?

Most likely the logger level, which has to be set to debug on the XWiki.LiveTableResultsMacros logger.

Related

• Live Data Sources