[Jaspersoft MongoDB Query Language: Aggregation and projection]

any new updates on this issue ?

[mongofb 3.6 JRException: The 'cursor' option is required, except for aggregate with the explain argument]

Hello,

i recentlly change my mongodb database version from 3.4 to 3.6 and i started getting this error : 

net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: The 'cursor' option is required, except for aggregate with the explain argument
    at com.jaspersoft.studio.editor.preview.view.control.ReportController.fillReport(ReportController.java:550)
    at com.jaspersoft.studio.editor.preview.view.control.ReportController.access$18(ReportController.java:525)
    at com.jaspersoft.studio.editor.preview.view.control.ReportController$1.run(ReportController.java:443)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: The 'cursor' option is required, except for aggregate with the explain argument
    at net.sf.jasperreports.components.list.VerticalFillList.prepare(VerticalFillList.java:150)
    at net.sf.jasperreports.engine.fill.JRFillComponentElement.prepare(JRFillComponentElement.java:152)
    at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:542)
    at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:453)
    at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:428)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2585)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:813)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:264)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:110)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:615)
    at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:135)
    at java.lang.Thread.run(Thread.java:748)
Caused by: net.sf.jasperreports.engine.JRException: The 'cursor' option is required, except for aggregate with the explain argument
    at com.jaspersoft.mongodb.query.MongoDbQueryWrapper.runCommand(MongoDbQueryWrapper.java:207)
    at com.jaspersoft.mongodb.query.MongoDbQueryWrapper.processQuery(MongoDbQueryWrapper.java:115)
    at com.jaspersoft.mongodb.query.MongoDbQueryWrapper.<init>(MongoDbQueryWrapper.java:93)
    at com.jaspersoft.mongodb.query.MongoDbQueryExecuter.createDatasource(MongoDbQueryExecuter.java:104)
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1257)
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:726)
    at net.sf.jasperreports.components.list.FillDatasetRun.start(FillDatasetRun.java:166)
    at net.sf.jasperreports.components.list.VerticalFillList.prepare(VerticalFillList.java:102)
    ... 11 more

when i try to run this script :

{
    runCommand: {
        aggregate : 'Org',
        pipeline : [
            {
                $project : {
                    
                    Miss_Attr.categorie:1,
                    Miss_Attr.texte:1
                }
            },
            { $unwind : '$Miss_Attr'}
       ]
}}

can anyone help me with this. thank you

[Jaspersoft MongoDB Query Language: Aggregation and projection]

any new updates on this issue ?

[No result, when adding cursor in JSS 6.6 for mongodb 3.6]

any new updates ?? i'm facing the same probléme

 

[Jaspersoft mongodb aggreation]

Hello,

i was using mongodb 3.4 ,i recently changed it to 4.0 .This is my  script that i used in jaspersoft studio to get data :

{
    runCommand: {
        aggregate : 'Unite_ORG',
        pipeline : [
            {
                $project : {
                    
                    Miss_Attr.categorie:1,
                    Miss_Attr.texte:1
                }
            },
            { $unwind : '$Miss_Attr'}
       ]

}}

the probléme is i'm getting this error and i don't know how to fix it :  net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: The 'cursor' option is required, except for aggregate with the explain argument

[Mongodb Atlas and jaspersoft studio]

Hello,

i'm using Jaspersoft Studio-6.9.0 and Mongodb Atlas 4.0, the problem i'm facing is that jaspersoft works finre with mongodb  hosted on my local machine but i'm facing problems when i try to connect it to Mongodb Atlas. can someone help me with if they faced the same probleme before. thanks in advance i appreciate the help.

Cordialement