search

jouke / loopback-auditz

Adds comprehensive audit trail functionality to Loopback by keeping track of who created/modified/deleted data and when they did it, and adds a revisions model compatible with Sofa/Revisionable for PHP (https://github.com/jarektkaczyk/revisionable)
Other
19 stars 12 forks source link

SoftDelete not working with MongoDB #4

Open hgoebl opened 7 years ago

hgoebl commented 7 years ago

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
itaimoorali commented 6 years ago

Whats the status on this @jouke ??? are fixing this ? i am having the same issue.