loopback-auditz
loopback-auditz copied to clipboard
SoftDelete not working with MongoDB
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
Whats the status on this @jouke ??? are fixing this ? i am having the same issue.