How to include NULL or None values for the "IN" clause query in pymongo?

Question

I want find the paths in mongodb which also contains None values if path is not present in database.

But problem is "IN" clause query only consider values which exists.

Here is my code.

veye_path = [path['dir_path'] for path in veye_db.find({"uuid": {"$in": binary_veye_uuid}})]

I also want to include None values as well.

Provide a small amount of data from the `veye_db` collection and identify which records are not working — Belly Buster, Jun 04 '20 at 14:42

score 0 · Answer 1 · answered Jun 04 '20 at 18:50

0

You could try:

{'$or': [{"uuid": {"$in": binary_veye_uuid},{"uuid": {"$exists": false}]}

answered Jun 04 '20 at 18:50

D. SM

{"uuid": {"$exists": false} it will check whole database for None values but I want records of previous day. – Hiba Rehman Jun 05 '20 at 13:40
Add additional conditions as needed. – D. SM Jun 05 '20 at 14:52

1 Answers1