Spring Data MongoDB: aggregation framework - sort with nested property throws invalid reference

Question

I found this article in Spring Forum which obviously dicusses partly the same problem, but has no answer to my question.

Given the following document...

{
    "_id": { "$oid": "5214b5d529ee12460939e2ba"},
    "title": "this is my title",
    "tags": [ "fun", "sport" ],
    "comments": [
        {
            "author": "alex",
            "text": "this is cool",
            "createdAt": 1
        },
        {
            "author": "sam",
            "text": "this is bad",
            "createdAt": 2
        },
        {
            "author": "jenny",
            "text": "this is bad",
            "createdAt": 3
        }
    ]
}

... I want to do this aggregation (Javascript) ...

//This is as concise as possible to focus on the actual problem which is the sort operation when ported to Spring!  
db.articles.aggregate( 
    {$unwind:"$comments"},
    //do more like match, group, etc...
    {$sort:{"comments.createdAt":-1}} //Sort descending -> here the problem occurs in Spring (works in Javascript!)
);

... but with Spring -> Throws Invalid Reference!

Aggregation agg = newAggregation(
       unwind("comments"),
       sort(Direction.DESC, "comments.createdAt") //Throws invalid reference 'comments.createdAt'!
       //How can I make this work? 
);

Of course I can do it with the native Java-Driver and without usage of Spring's MongoTemplate but I don't like this approach very much. What can I do to make this exact aggregation work with Spring?

I am using the current Version 1.4.0.RELEASE.

Works for me. Can you please show Post and Comment mapping?

Ori Dar
– Ori Dar

2014-03-10 13:17:48 +00:00
Commented Mar 10, 2014 at 13:17 — Ori Dar
– Ori Dar, Commented Mar 10, 2014 at 13:17

Patrick Meier · Accepted Answer · 2014-03-10 15:24:39Z

3

The code as posted indeed works successfully - the problem I had was something else.

I did something like this:

Aggregation agg = newAggregation(
       project("comments"), //This was the problem! Without this it works as desired!
       unwind("comments"),
       sort(Direction.DESC, "comments.createdAt") 
);

As I wrote in the code I wanted to project only the comments-Field to save some overhead - but this acutally caused my problem!

Thanks a lot for the hint!

answered Mar 10, 2014 at 15:24

Patrick Meier

4541 gold badge6 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Spring Data MongoDB: aggregation framework - sort with nested property throws invalid reference

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related