Recently we were trying to make our mongo DB based application case insensitive and for testing we needed to find all document containing lowercase alphabets in a filed called "sku". The following query was able to do the work.
{"$expr": {"$ne": ["$sku", {"$toUpper": "$sku"}]}}
Please note that this query does not work on AWS DocumentDB.
No comments:
Post a Comment