loopback-auditz icon indicating copy to clipboard operation
loopback-auditz copied to clipboard

SoftDelete not working with MongoDB

Open hgoebl opened this issue 7 years ago • 1 comments

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

hgoebl avatar Apr 04 '17 17:04 hgoebl

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

itaimoorali avatar Nov 16 '17 06:11 itaimoorali