mongodb, how to use $not filter in query

Question

I have what should be a fairly simple query I'm trying to run in mongodb compass:

{ $and: [ { Source: "hostname" }, { Message: { $not: /.*unexpected data.*1234.*/ } } ] }

Basically, my document model contains a Source field and a Message field.

I need to query for all documents where the Source equals a given "hostname" and the Message does not contain "unexpected data...1234"

Everything works fine when I DO NOT include the $not filter on the regular expression... so I get all the documents where this message is contained... but now I need all the other messages where this is NOT contained... and I can't figure out how to use $not properly.

The example given in the MongoDb manual only shows using $not with one statement... but even this doesn't work for me for some reason...

{ Message: { $not: /.*unexpected data.*1234.*/ } }

Again, it works fine without the $not... what am I missing?

Edit:

Here is an image of what I'm talking about, placing this filter in MongoDb Compass, it indicates that the filter is incorrect... Is MongoDb Compass for some reason incapable of running complex filters?

Dexter · Accepted Answer · 2019-08-30 02:45:18Z

4

Please try with $regex which should work:

find( { $and: [ { Source: "hostname" }, { Message: { $not: { $regex: /.*unexpected data.*1234.*/ } } } ] })

edited Aug 30, 2019 at 2:45

answered Aug 30, 2019 at 2:32

Dexter

9928 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

eerick Over a year ago

Strangely enough, I tried that first and it didn't work either... Is there something else that could be causing the $not filter to not function?

Dexter Over a year ago

it works for me. Check out the screenshot that I've attached. Please post the error message you get

eerick Over a year ago

thanks for the example! I made an edit to my question and added the filter example... MongoDb Compass indicates this filter is incorrect in some way but does not say how... what application are you using to run your example, maybe I can try it there instead?

Dexter Over a year ago

I use Robo 3T - 1.2. If it works, please accept the answer to get this to closure

blakemade · Accepted Answer · 2020-02-11 00:43:51Z

0

MongoDB Compass only supports regex surrounded by single quotes, not forward slashes. So $regex: /.*unexpected data.*1234.*/ should be $regex: '.*unexpected data.*1234.*'.

https://jira.mongodb.org/browse/COMPASS-2993

answered Feb 11, 2020 at 0:43

blakemade

1076 bronze badges

Collectives™ on Stack Overflow

mongodb, how to use $not filter in query

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related