MongoDB & Birt Aggregation
Hi
I'm trying to create reports in BIRT, but I'm getting some errors when I execute an aggregation command to join two or more collections. Is there a way to properly execute the queries, like a patch or a fix?
The following error shows as follow:
org.eclipse.datatools.connectivity.oda.OdaException: Unable to run the Aggregate command operation.
Check that your connected MongoDB server is version 2.2 or later. ;
com.mongodb.CommandFailureException: { "serverUsed" : "myhost:27017" , "ok" : 0.0 , "errmsg" : "The 'cursor' option is required, except for aggregate with the explain argument" , "code" : 9 , "codeName" : "FailedToParse"}...
How can I use the 'cursor' option in the command? Is there another way to join two or more collections in BIRT?
I'll be grateful if I get an answer.
Regards
Comments
-
I do not have a MongoDB environment to test on, but I found this:
https://stackoverflow.com/questions/47472688/spring-data-mongodb-the-cursor-option-is-requiredYou also asked if there is a way to join "collections" in BIRT. BIRT uses data sets to get the data. One of the options when you create a data set is to create a "joint data set". You can use this feature to take two queries and effectively join them inside of BIRT,
Warning No formatter is installed for the format ipb0
Categories
- All Categories
- 108 Developer Announcements
- 53 Articles
- 106 General Questions
- 145 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 899 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 120 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management