SoftDelete not working with MongoDB #4
Description
The "not-deleted" filter queryNonDeleted = {[options.deletedAt]: null} is translated into { deleted_at: { '$type': 10 } }. This query won't find any record. What we'd need is more like deleted_at: {$exists: false}. Unfortunately I don't know whether there is an expression which gets translated to this and hopefully stills works with other databases.
Maybe using "deletedBy" would be easier than using a date?
From server log:
2017-04-04T16:54:47.309Z - debug: loopback:connector:mongodb all news { limit: 10, skip: 0, where: { deleted_at: null }, offset: 0 } +1ms
2017-04-04T16:54:47.309Z - debug: loopback:connector:mongodb MongoDB: model=news command=find [ { deleted_at: { '$type': 10 } }, [Function] ] +1ms