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; } } }

Parameter Select All beforeOpen script

abrumar

<p>I am able to replicate JasonW's example to get (All) parameter to function properly, locally with the ClassicModels sample Db but am having trouble getting it to work with my data.</p>
<p> </p>
<p><a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/667-all-parameter-values/'>http://developer.actuate.com/community/forum/index.php?/files/file/667-all-parameter-values/</a></p>
<p> </p>
<p>> I have added "(All)" to my dataset used to create the Category parameter as so:</p>
<p> </p>
<p>union (select '(All)' as CATEGORY from root.AE_S_CAT_C)</p>
<p> </p>
<p>> Have set the default value of the dynamic Category parameter to (All)</p>
<p> </p>
<p>and have modified the beforeOpen script on my main dataset to read:</p>
<p> </p>
<div>category_Param = "'" + params["Category"].value.join("','") + "'";</div>
<div>if (category_Param.match("(All)") == null){ </div>
<div>this.queryText = this.queryText + " and CATEGORY IN (" + category_Param + ")";</div>
<div>}</div>
<div> </div>
<div>I have also tried it with schemaName.tableName. in front of CATEGORY field in last line of code.</div>
<div> </div>
<div>When attempting to run with default (All) selected I get NO results, when I try to select a single or multiple Categories, I get java exception errors.</div>
<div> </div>
<div>any advice appreciated.</div>

Find more posts tagged with

Comments

JFreeman

<p>I think the best place to start is to log out the query you are building by outputting this.queryText on the last line of your beforeOpen script.</p>
<p> </p>
<p>Then examine the query that is constructed for accuracy and run it outside of BIRT against the database.</p>
<p> </p>
<p>Odds are something is wrong with the query being built and that should help you isolate what's wrong.</p>

abrumar

<p>Sounds reasonable but how do I "<span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">log out the query you are building by outputting this.queryText"</span><br>
</p>

JFreeman

<p>There are multiple ways depending on the version of BIRT you are using.</p>
<p> </p>
<p>The simplest way is to open the designer with eclipsec instead of eclipse to launch the console output window with the designer. Then in your scripting you can use the java.lang package to output to the console window.</p>
<p>For example:</p>
<pre class="_prettyXprint _lang-js">
Packages.java.lang.System.out.println(this.queryText);
</pre>
<p>Alternatively, you could also use Java or Javascript to write to an output file or implement a logging class.</p>
<p> </p>
<p>If you are using the commercial version of the designer, implementing a logger is quite simple, and the output will be written directly into Eclipse's Error Log window.</p>
<pre class="_prettyXprint _lang-js">
logger = java.util.logging.Logger.getLogger("birt.report.logger");
logger.warning(this.queryText);
</pre>