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
Birt mongodb param
Migrateduser
<div>
<p>I installed Birt 4.3 (latest) as Eclipse plugin. JDBC as data source works perfectly for me. I define a param in query. I can define a param in data set via Report Design and link it to a report param.</p>
<p>But I have multiple issues with MongoDB</p>
<p>1) When I open "edit data set" dialog I cannot find the menu "Parameters" in left side. I only see Data Source Query Output Columns Computed Columns Filters properties Binding Setting Review Results</p>
<p>No Parameter any more. I can see it in JDBC not in MongoDB Could anyone please how to define a parameter in data set while Data source is MongoDB? How to link the param to the param of report?</p>
<p>In earlier version I could see the menu "Parameters" in left side for MongoDB as JDBC</p>
<p> </p>
<p>The attached file shows there was a menu "Parameters" in left side for MongoDB in earlier version. But now there isn't anymore. Why? How to input params?</p>
<p> </p>
<p>2) In MongoDB (Birt) how to define a parameter in the expression of "Run Database Command" or in query In JDBC we can use "?" as a param holder like</p>
<p>select * where id=?</p>
<p>param will replace "?"</p>
<p>For MongoDB</p>
<pre>
{
runCommand : {
aggregate : COLLECTION_NAME,
.....
}
}
</pre>
<p>COLLECTION_NAME is vary. How can I represent it?</p>
<p> </p>
<p>I used Jasper who allows us to define some params in query of MongoDB. At run-time it replaces the params with real values. I cannot find the similar way in Birt.</p>
<p> </p>
<p>Any help will be appreciated.</p>
<p>Thanks</p>
</div>
<p> </p>
Find more posts tagged with
Comments
There are no comments yet