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

Table conditional filter script not work on server

guns21

Hi all 
My coworker try to add conditional filter on table and follow the example from <a class='bbc_url' href='http://birtworld.blogspot.tw/2010/06/conditional-table-filters.html.'>http://birtworld.blogspot.tw/2010/06/conditional-table-filters.html.</a> And it works on designer, but failed on Tomcat. He put the script on the table in the onPrepare method. 
<pre class='_prettyXprint _lang-auto _linenums:0'>
importPackage( Packages.org.eclipse.birt.report.engine.api.script.element );
importPackage( Packages.org.eclipse.birt.report.model.api.simpleapi );

if(params["Item_Number"].value!= null){
var filterCondition = StructureScriptAPIFactory.createFilterCondition();
filterCondition.setExpr("row['Data Set1::Data Set::Item_Data::ITEM_NUMBER']");
filterCondition.setOperator("eq");
filterCondition.setValue1("params[\"Item_Number\"]");

var filterKey = filterCondition.getStructure();
var filterItem = SimpleElementFactory.getInstance().createFilterCondition( filterKey )
this.addFilterCondition( filterItem );
}

if(params["UnderSafeOnhand"].value == "Y"){
var filterCondition = StructureScriptAPIFactory.createFilterCondition();
filterCondition.setExpr("row['Total Onhand']");
filterCondition.setOperator("lt");
filterCondition.setValue1("row['Data Set1::Data Set::Item_Data::SAFETY_QUANTITY']");

var filterKey = filterCondition.getStructure();
var filterItem = SimpleElementFactory.getInstance().createFilterCondition( filterKey )
this.addFilterCondition( filterItem );
}
</pre>
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "importPackage( Packages.org.eclipse.birt.report.engine.api.script.element ); importPackage( Packages.org.eclipse.birt.report.model.api.simpleapi ); if(params["Item_Number"].value!= null){ var filterCondition = StructureScriptAPIFactory.createFilterCondition(); filterCondition.setExpr("row['Data Set1::Data Set::Item_Data::ITEM_NUMBER']"); filterCondition.setOperator("eq"); filterCondition.setValue1("params[\"Item_Number\"]"); var filterKey = filterCondition.getStructure(); var filterItem = SimpleElementFactory.getInstance().createFilterCondition( filterKey ) this.addFilterCondition( filterItem ); } if(params["UnderSafeOnhand"].value = "Y"){ var filterCondition = StructureScriptAPIFactory.createFilterCondition(); filterCondition.setExpr("row['Total Onhand']");
filterCondition.setOperator("lt"); filterCondition.setValue1("row['Data Set1::Data Set::Item_Data::SAFETY_QUANTITY']"); var filterKey = filterCondition.getStructure(); var filterItem =
SimpleElementFactory.getInstance().createFilterCondition( filterKey ) this.addFilterCondition( filterItem ); }": TypeError: Cannot call method "setExpr" of null (/report/body/table[@id="22"]/method[@name="onPrepare"]#17) (Element ID:22)
</pre>

Find more posts tagged with

Comments

guns21

Oops !! It seems a bad question. Maybe change another application server?

mwilliams

Did you get this resolved? I wasn't sure based on your last post. Let me know.

guns21

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="111844" data-time="1353953928" data-date="26 November 2012 - 11:18 AM">
Did you get this resolved? I wasn't sure based on your last post. Let me know. </blockquote>
Thanks your reply. Not resolved yet. For now, I just finished upgrading a Tomcat server.

mwilliams

Can you recreate your issue, with the sample database, so I can test it, too? This way we can work with the same report and try to figure it out. Thanks.

guns21

Thanks. Check attachment please.

guns21

After replace 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>StructureScriptAPIFactory.createFilterCondition();</pre> 
to 
<pre class='_prettyXprint _lang-auto _linenums:0'>SimpleElementFactory.getInstance().createFilterCondition();</pre>
 
,error messages gone! It seems engine don't accept deprecated method on Server.

mwilliams

Ah. Great! Glad you got it working! Let us know whenever you have questions!