MongoDB & Birt Aggregation

rcastro_1996

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

jfranken

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-required

You 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,