Passing parameters from Java to Birt report wsdl dataset request attributes runtime

<p>Hi,</p>
<p> </p>
<p>I am new to BIRT reproting. I know how to pass parameters from java to BIRT design report and bind the paramters to the soap dataset request. However, my request has attributes in the xml element. For example:</p>
<p> </p>
<div><SOAP-ENV:Envelope</div>
<div>xmlns:xsd="<a data-ipb='nomediaparse' href='http://www.w3.org/2001/XMLSchema'>http://www.w3.org/2001/XMLSchema"</a></div>
<div>xmlns:SOAP-ENC="<a data-ipb='nomediaparse' href='http://schemas.xmlsoap.org/soap/encoding/'>http://schemas.xmlsoap.org/soap/encoding/"</a></div>
<div>xmlns:xsi="<a data-ipb='nomediaparse' href='http://www.w3.org/2001/XMLSchema-instance'>http://www.w3.org/2001/XMLSchema-instance"</a></div>
<div>xmlns:SOAP-ENV="<a data-ipb='nomediaparse' href='http://schemas.xmlsoap.org/soap/envelope/'>http://schemas.xmlsoap.org/soap/envelope/"></a></div>
<div><SOAP-ENV:Body></div>
<div><m:myRequest xmlns:m="<a data-ipb='nomediaparse' href='http://www.hipaat.com/schemas/cms/v2.1'>http://www.hipaat.com/schemas/cms/v2.1"></a></div>
<div> </div>
<div> <m:requestId><span style="color:#008000;">&?requestIdParam?&</span></m:requestId></div>
<div> </div>
<div> <m:userId><span style="color:#008000;">&?userIdParam?&</span></m:userId></div>
<div> </div>
<div> <m:request></div>
<div> </div>
<div> </div>
<div><span style="color:#ff0000;"><strong> <m:GetProducts orderId="1" orderDate="2015-12-30-04:00"/></strong></span></div>
<div> </div>
<div></m:request></div>
<div> </div>
<div></m:myRequest></div>
<div></SOAP-ENV:Body></div>
<div></SOAP-ENV:Envelope></div>
<div> </div>
<div> </div>
<div>I know how to pass the requestIdParam and the userIdParam from java to the report. However, also I need to pass the orderId and the orderDate as parameters or I need to replace the values at runtime.</div>
<div> </div>
<div>Can anyone point me to the right direction how to pass the attributes orderId and orderDate?</div>
<div> </div>
<div>Thanks.</div>

Find more posts tagged with

Comments

Clement Wong

<p>If you are not able to parameterize those variables, then you have access to the XML string in the <em>beforeOpen </em>event of the DataSet.</p>
<p> </p>
<p>There, you can do replace your existing string (<m:GetProducts orderId="1" orderDate="2015-12-30-04:00"/>) with values that come from your parameters (e.g. params["orderID"].value). You will need to escape the double quotes. </p>
<p> </p>
<p><span style="font-family:'courier new', courier, monospace;">this.queryText = this.queryText.replace(oldStr,newStr);</span></p>
<p> </p>
<p>You may need to debug and write out this.queryText to make sure that you have the format/syntax correct. If you're using commercial BIRT, then you can easily write out the XML string to the Eclipse's error log with logger = java.util.logging.Logger.getLogger("birt.report.logger");. Otherwise, you'll need other means to write that string out to verify.</p>