Eclipse Community Forums: BIRT » Expression text for mongo aggregate query in BIRT

Home » Archived » BIRT » Expression text for mongo aggregate query in BIRT(What is the syntax of the expression text for an aggregate query on mongo db?)

Show: Today's Messages :: Show Polls :: Message Navigator

Expression text for mongo aggregate query in BIRT [message #1713428]

Wed, 04 November 2015 05:35

Kanj Narayan

Messages: 1
Registered: November 2015

Junior Member

I use the following command in mongo to list the required result:

db.test.aggregate([ {$group:{_id:{"code_":"$code","type_":"$type"}, total:{$sum:"$value"}}}, {$group:{_id:"$_id.code_", details:{$addToSet:{"type":"$_id.type_","tot":"$total"}}}} ])

How can I get the same result in BIRT using custom database command? What is the syntax of the query expression?

Report message to a moderator

Previous Topic:	How to manipulate certain values from a multi-value parameter
Next Topic:	Highlight cell in crosstab causes stackoverflow in webviewer but not in eclipse

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 17:19:10 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter