Obtain resultset SQL obtains during execution

brendanCrowley

<p>For an OODA Data Set the queryText is set in a beforeOpen script - for this SQL that is executed is it possible to obtain the resultset it obtains during execution of the SQL? If so, what do i need to do?</p>
<p> </p>
<div>Actuate BIRT Designer Professional </div>
<div>Version: 11.0.4</div>
<div>Build id: 20140722</div>

Clement Wong

<p>What's your use case?</p>
<p> </p>
<p>Does the <em>onFetch </em>event of the Data Set suit your needs?  Since you are using commercial BIRT, you can use this debug logger to write out the the Designer's "Error Log" in the lower right pane.  In the example, below, I'm writing out the column "CUSTOMERNUMBER".</p>
<pre class="_prettyXprint">
logger = java.util.logging.Logger.getLogger("birt.report.logger");
logger.warning ("In onFetch...");
logger.warning (row["CUSTOMERNUMBER"]);</pre>
<p>If required, you can also execute a query way before the Data Set, in the <em>beforeFactory</em>, and obtain the results there.</p>