Allow $expr or $$field in the $geoNear stage

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Duplicate
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Aggregation Framework
    • None
    • Query Optimization
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      When trying to use a $lookup with pipeline and a $geoNear stage, there is no way to pass an argument in the let field into the $geoNear stage.

      e.g.

      { 
            "$lookup" : {
                "from" : "regions", 
                "let" : {
                    "point" : "$location"
                }, 
                "pipeline" : [
                    {
                        "$geoNear" : {
                            "spherical" : true, 
                            "maxDistance" : 10000.0, 
                            "distanceField" : "distance", 
                            "uniqueDocs" : true, 
                            "near" : "$$point"
                        }
                    }
                ], 
                "as" : "regions"
            }
}

            Assignee:
            [DO NOT USE] Backlog - Query Optimization
            Reporter:
            Travis Brown
            Votes:
            24 Vote for this issue
            Watchers:
            37 Start watching this issue

              Created:
              Updated:
              Resolved: