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

cannot have two conditions in match if one is ISODate

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major - P3 Major - P3
    • 1.17.0, 1.18.0
    • 1.15.4
    • Compass
    • None
    • Mac OS
      MongoDB version 4.0.2 Enterprise

    Description

      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.

       

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: