I'm using loopback js for backend rest api. I'm switching from Mysql to Mongodb.
I have been using query filters like these:
{filter:{where:{fieldName:null}}}
This works fine with mysql but when switching to mongodb it dosen't work. https://docs.mongodb.com/v3.2/tutorial/query-for-null-fields/ It is supported as document says. Am I missing some configurations for loopback?
My goal is to change mysql to mongodb without updating any queries.
The connector is turning your query into command=find [ { fieldName: { '$type': 10 } },
You can add this to your datasource object to use the extended operators and regain your functionality.
"allowExtendedOperators": true
ex
{ "where": { "or": [ { "name": null }, {"name": { "exists": false } } ] } }
: equality operator in case of null. You could also enforce field creation in mongodb and keep using "name": null. This might be a necessary consequence of switching from a relation database to a document store.You do not need the "where" when querying in MongoDB.
Can you try querying this instead?
db.coll.find({fieldName: null})
