Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
beforeOpen
Migrateduser
I am getting this error when trying to add a very simple beforeOpen query adjustment:
org.eclipse.birt.report.engine.api.EngineException: Cannot get the result set metadata. org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object. SQL error #1:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'undefined WHERE A.InvoiceNumber = '771990'' at line 1 ; com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'undefined WHERE A.InvoiceNumber = '771990'' at line 1
The beforeOpen is simply this:
<method name="beforeOpen"><![CDATA[
var whereClause = "";
if (params["VendorName"].value != "" && params["VendorName"] != null) {
whereClause = " WHERE A.InvoiceNumber = '771990'";
this.queryText = this.QueryText + whereClause;
}
]]></method>
The VendorName parameter is a "Not Required" string.
Report is also attached.
Find more posts tagged with
Comments
There are no comments yet