Shouldn't pagination exclude deleted items?

[yoieh]

Shouldn't pagination exclude deleted items?

[JKHeadley]

@yoieh Thanks for bringing this up. Soft delete is a tricky feature to manage and I'm definitely open to ideas. For your needs I think the current solution would be to select documents with isDeleted equal to false within the query itself, like so:

http://localhost:8080/permission?$page=2&$limit=10&isDeleted=false

This will give you proper pagination values excluding deleted documents. Does this make sense?

[yoieh]

In my case I still need the deleted documents to be able to remove them from the client. But yes i went with a costume rout as a "sync route". That takes a lastSync=DATE. Then I'm doing the "get list" call with isDeleted=false. Not really optimal to do to calls every time an client updates but it works and also enables an case to update cached documentss on my client. Still there are some other problems with the amount of data that could be receiving buy a new user..
this what's why I needed a way to just know the amount of deleted items of the total.

[JKHeadley]

@yoieh lets move the conversation to your PR: #236