Group by field

[FrEaKmAn]

Hello

I'm interested how to run this query

    db.parties.group({
            key: { start: 1 },
            cond: { start: { $gt: new Date( '01/01/2012' ) } },
            $reduce: function ( curr, result ) { result.count++ },
            initial: { count : 0 }
    });

I tried with

    MapReduceCommand command = new MapReduceCommand(Party.col(), "{ start: 1 }", "function ( curr, result ) { }", "count", MapReduceCommand.OutputType.REPLACE, null);
    MapReduceOutput output = Party.col().mapReduce(command);

But I always get 0 results. Any ideas how to make it work?

[greenlaw110]

Can you try

AggregationResult byStart = Party.q().filter("start >", new
Date("01/01/2012")).groupCount("start");
System.out.println(byStart.get("start", "02/01/2012");

Check http://www.playframework.org/modules/morphia-1.2.12/statistics#group

On Mon, Dec 31, 2012 at 10:36 PM, FrEaKmAn notifications@github.com wrote:

Hello

I'm interested how to run this query

db.parties.group({
        key: { start: 1 },
        cond: { start: { $gt: new Date( '01/01/2012' ) } },
        $reduce: function ( curr, result ) { result.count++ },
        initial: { count : 0 }
});

I tried with

MapReduceCommand command = new MapReduceCommand(Party.col(), "{ start: 1 }", "function ( curr, result ) { }", "count", MapReduceCommand.OutputType.REPLACE, null);
MapReduceOutput output = Party.col().mapReduce(command);

But I always get 0 results. Any ideas how to make it work?

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/102.

[FrEaKmAn]

Hello

If I do byStart.getResult() I get 2 results, but when I try byStart.getResult("start", "02/01/2012"); I always get null. I tried also other dates, maybe format is different? I there a way to list all groups?

[greenlaw110]

byStart.getResult() returns the first group count in the result. To list
all groups, use byStart.getResult().raw(), which returns a list
of BasicDBObject coming from MongoDB driver.

On Wed, Jan 2, 2013 at 11:47 PM, FrEaKmAn notifications@github.com wrote:

Hello

If I do byStart.getResult() I get 2 results, but when I try
byStart.getResult("start", "02/01/2012"); I always get null. I tried also
other dates, maybe format is different? I there a way to list all groups?

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/102#issuecomment-11806825.

[FrEaKmAn]

Hello

But byStart.getResult() returns Long so there is no raw method. If I do byStart.raw(), I get [ { "start" : 2.0}].. not the result I want...

[greenlaw110]

can you actually send a minimum set of your project to me so I can continue
working on this issue?

On Fri, Jan 4, 2013 at 4:00 AM, FrEaKmAn notifications@github.com wrote:

Hello

But byStart.getResult() returns Long so there is no raw method. If I do
byStart.raw(), I get [ { "start" : 2.0}].. not the result I want...

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/102#issuecomment-11851289.

[greenlaw110]

Please try the latest version 1.2.14. You need to download the version from http://gelinsoft.com/play/repo/. Or update your dependencies.yml file according to https://gist.github.com/2868365

[greenlaw110]

@FrEaKmAn do you still have the issue in the 1.2.14 version?

[FrEaKmAn]

No, I think it was fixed. Thank you!