Hi,

I wanted to query something like get results that does not satisfy this regex (non case sensitive).

But what is see as part of mongodb documentation is:

$not is not supported for regular expressions specified using the {$regex: ...} syntax. When using $not, all regular expressions should be passed using the native BSON type (e.g. {"$not": re.compile("acme.*corp")} in PyMongo)

I get a similar message when i use not() and regex() together on spring Criteria API .


As suggestion how could i achieve the same.


Regards,
Suraj