Filters in subdocuments can't use fields from the parent document

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Done
    • Priority: Major - P3
    • 2.14.0
    • Affects Version/s: 2.4.1
    • Component/s: LINQ
    • None
    • Environment:
      ASP.NET Core
    • None
    • None
    • None
    • None
    • None
    • None

      Using a filter via .Where() inside a Select uses the subdocument's value instead of the parent document's.
      i.e:

      // Some comments here
select new
{
    Prev = prev.Where(x => x.LastActionTime < visit.FirstActionTime && x.VisitorId != null)
} into r

      Expected result:

      "Prev": {
                "$filter": {
                    "input": "$prev",
                    "as": "x",
                    "cond": {
                        "$and": [
                            {
                                "$lt": [
                                    "$$x.LastActionTime",
                                    "$FirstActionTime"
                                ]
                            },
                            {
                                "$ne": [
                                    "$$x.VisitorId",
                                    null
                                ]
                            }
                        ]
                    }
                }
            },

      Actual result:

      "Prev": {
                "$filter": {
                    "input": "$prev",
                    "as": "x",
                    "cond": {
                        "$and": [
                            {
                                "$lt": [
                                    "$$x.LastActionTime",
                                    "$$x.FirstActionTime"
                                ]
                            },
                            {
                                "$ne": [
                                    "$$x.VisitorId",
                                    null
                                ]
                            }
                        ]
                    }
                }
            },

              Assignee:
              James Kovacs
              Reporter:
              Daniel Rusznyak
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: