Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
param of birt in query mongodb
rafex
<p>I design a report with Birt on datasource mongoDB, when i create a dataset i can select a collection and select the data for my report, but i need using a filter to select only any document not all, so i have a param (factura=1000) created in Birt.</p>
<p> </p>
<p>So, in query expression i put:</p>
<p> </p>
<p>{"data.dam.fac.num":"'+params["factura"].value+'"} </p>
<p> </p>
<p>but i have error when see preview result, the error is:</p>
<p> </p>
<div>org.eclipse.datatools.connectivity.oda.OdaException: Error in parsing the JSON expression: {"data.dam.fac.num":"'+params["factura"].value+'"} ;</div>
<div> com.mongodb.util.JSONParseException: </div>
<div>{"data.dam.fac.num":"'+params["factura"].value+'"}</div>
<div> </div>
<div> </div>
<div>How, i can doit this??</div>
Find more posts tagged with
Comments
Clement Wong
<p>Please take a look at this response:</p>
<p><a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/forum/index.php?/topic/34993-birt-mongodb-param/?p=129789'>http://developer.actuate.com/community/forum/index.php?/topic/34993-birt-mongodb-param/?p=129789</a></p>
;
<p> </p>
<p>Or this one:</p>
<p><a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/forum/index.php?/topic/39595-report-parameters-to-insert-a-list-into-a-mongodb-query/?p=145349'>http://developer.actuate.com/community/forum/index.php?/topic/39595-report-parameters-to-insert-a-list-into-a-mongodb-query/?p=145349</a></p>
;