[Backlogmanager] [FIWARE-JIRA] (HELP-13402) [fiware-stackoverflow] MongoDb: Aggregation using Groovy language

[Fernando Lopez (JIRA)]

     [ https://jira.fiware.org/browse/HELP-13402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fernando Lopez deleted HELP-13402:
----------------------------------


> [fiware-stackoverflow] MongoDb: Aggregation using Groovy language
> -----------------------------------------------------------------
>
>                 Key: HELP-13402
>                 URL: https://jira.fiware.org/browse/HELP-13402
>             Project: Help-Desk
>          Issue Type: Monitor
>            Reporter: Backlog Manager
>              Labels: aggregation-framework, fiware, groovy, mongodb, spagobi
>
> Created question in FIWARE Q/A platform on 08-09-2015 at 16:09
> {color: red}Please, ANSWER this question AT{color} https://stackoverflow.com/questions/32459956/mongodb-aggregation-using-groovy-language
> +Question:+
> MongoDb: Aggregation using Groovy language
> +Description:+
> Iam using groovy scripting under SpagoBI. I want to use aggregation.
> I want for example to execute the following aggregation:
> db.myCollection.aggregate(
>    [
>       {
>         $group : {
>            _id : { day: { $dayOfMonth: "$recvTime" } }
>         }
>       }
>    ]
> )
> I tried:
> DBObject projectFields = new BasicDBObject('$dayOfMonth',"recvTime");
> DBObject project=new BasicDBObject('$project',projectFields)
> DBObject groupFields = new BasicDBObject( "_id",project);
> DBObject group = new BasicDBObject('$group', groupFields);
> iterable = db.getCollection('myCollection').aggregate(group)  
> I got this error:
> An unexpected error occured while executing dataset: { "serverUsed" : "192.168.1.160:27017" , "errmsg" : "exception: invalid operator '$project'" , "code" : 15999 , "ok" : 0.0}
> Any ideas?
> Updates:
> the query executed in Mongo shell
> db['cygnus_/kurapath_enocean_power_enocean'].aggregate(
> ...    [
> ...       {
> ...         $group : {
> ...            _id : { day: { $dayOfMonth: "$recvTime" } }
> ...         }
> ...       }
> ...    ]
> ... );
> { "_id" : { "day" : 9 } }
> { "_id" : { "day" : 8 } }
> { "_id" : { "day" : 7 } }
> { "_id" : { "day" : 4 } }
> { "_id" : { "day" : 3 } }
> the data stored in mongo db:
> db['cygnus_/kurapath_enocean_power_enocean'].find()
> { "_id" : ObjectId("55e81e9631d7791085668331"), "recvTime" : ISODate("2015-09-03T10:19:02Z"), "attrName" : "power", "attrType" : "string", "attrValue" : "2085.0" }
> { "_id" : ObjectId("55e81e9631d7791085668332"), "recvTime" : ISODate("2015-09-03T10:19:02Z"), "attrName" : "power", "attrType" : "string", "attrValue" : "2085.0" }
> { "_id" : ObjectId("55e81e9831d7791085668333"), "recvTime" : ISODate("2015-09-03T10:19:04Z"), "attrName" : "power", "attrType" : "string", "attrValue" : "2077.0" }



--
This message was sent by Atlassian JIRA
(v6.4.1#64016)