Question 1: Is $regex operater, by any chance made obsolete??
I run the following, and get an output of 83 (which is correct)
I modify the above query and fire it without the $regex operator, and get the same results.
We are able to search on regular expressions, without using the $regex operator. So is it right to assume that the $regex operator is obsolete?
Question 2: Moreover, why is $regex operator not working in Compass?
I put the following filter, and my FIND button remains disabled. (though screenshot doesn’t show it is disabled, but trust me it is disabled)
I change my find to the following and FIND button gets enabled, and when clicked, returns 83 matches as expected.
So based on above two,
(1) $regex operator doesn’t seem to work in Compass.
(2) Although it works in Mongo Shell, but seems to be obsolete.
Request you to please explain this behavior with $regex operator.