nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Logging queries for filling the parameter screen

AnnaB

Hi, 
 
I'm trying to track the queries in my reports. For "data" queries I can use this in the beforeOpen(): 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
logger = Packages.org.apache.log4j.Logger.getLogger(vars["loggerName"]);
logger.debug(this.getName());
logger.debug(this.queryText);</pre>
 
This will make them show up in the log, no problem. 
 
However, I have a couple of data sets ("filters") which I only use to fill parameter dropdown lists. They aren't logged by this method. Does anyone know how I can track these?

Find more posts tagged with

Comments

mwilliams

For reports with parameter dataSets, you could possibly do something like this in your beforeFactory to grab the query text:

reportContext.getDesignHandle().findDataSet("DataSetName").getStringProperty("queryText");