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

$not cannot be used with regEx

XMLWordPrintableJSON

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 1.20.0
    • Affects Version/s: 1.19.12
    • Component/s: Query Bar
    • None
    • Iteration Newt

      $not cannot be used with regEx in MongoDB Compass 1.19.6 as well as latest version 1.19.12. The same query is working fine in Mongo Shell.

      Query Example:

      { name: { $not: /^H.*/ } }

{ name: { $not: { $regex: "^H.*" } } }

      Please see attached images.

       

       

       

       

       

       

        1. image-2019-09-25-14-30-20-175.png
          image-2019-09-25-14-30-20-175.png
          70 kB
        2. image-2019-09-05-10-38-28-923.png
          image-2019-09-05-10-38-28-923.png
          153 kB
        3. image-2019-09-05-10-38-08-949.png
          image-2019-09-05-10-38-08-949.png
          148 kB
        4. image-2019-09-05-10-37-38-852.png
          image-2019-09-05-10-37-38-852.png
          17 kB
        5. image-2019-09-05-10-36-56-803.png
          image-2019-09-05-10-36-56-803.png
          22 kB

            Assignee:
            durran.jordan@mongodb.com Durran Jordan
            Reporter:
            tanna.matan@mongodb.com Tanna Matan
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: