Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
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>
;