Uploaded image for project: 'Compass '
  1. Compass
  2. COMPASS-3194

cannot have two conditions in match if one is ISODate

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 1.17.0, 1.18.0
    • Affects Version/s: 1.15.4
    • Component/s: Compass
    • Labels:
      None
    • Environment:
      Mac OS
      MongoDB version 4.0.2 Enterprise

      IHAC who is trying to run two query conditions in the same $match stage from the aggregations component in Compass, but receives error "Expected end of input but "}" found" (both Compass version 1.15.1 and 1.15.4).

      Example: { device:ObjectId('5baa4e604d7d0600019d8e95'), ts:

      { '$gte': ISODate('2018-10-04T18:30:00.000Z'), '$lte': ISODate('2018-10-05T18:29:59.999Z') }

      }

       

      I have been able to reproduce the error using the same Compass Version (1.15.4) and MongoDB version 4.0.2 Enterprise.

       

      Workaround which customer is using is to to run the two query conditions in separate $match stage through compass.

       

      Have tested using two conditions which does not include ISODate and expected results return.

       

      Can you please confirm if this is a bug with Compass, if so will there be a fix?

       

      Thanks in advance.

       

            Assignee:
            durran.jordan@mongodb.com Durran Jordan
            Reporter:
            lian.ngian@mongodb.com Lian Ngian (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: